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.

Article ID:000004760

Software:
  • 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