English

Problem: Opening an OLE DB table in ArcMap and switching to the 'selected records only' window returns all records

Description

This behavior will be apparent when using the Jet 4.0 OLE DB provider to make a connection to an Access database (.mdb file) and opening a table, which has an index field capable of behaving as a pseudo ObjectID*, in ArcMap. Make a selection from the table and switch the table window to show only the selected records. ALL the records are shown as selected.

See Related Information below.

Cause

This is a known issue.

Solution or Workaround

Make the OLE DB connection using an appropriate ODBC driver and the Microsoft OLE DB provider for ODBC drivers.

Related Information