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

Last Published: April 25, 2020


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.


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.

Article ID:000004760

  • ArcMap 8 x

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Related Information

Discover more on this topic