HOW TO

Enable Select by Attribute on an OLE DB table

Last Published: January 27, 2022

Summary

An OLE DB table that has a unique, not null, indexed field can support selections. This field can be used as a pseudo ObjectID field. In addition, any OLE DB table that has such an index will be able to participate fully in a relate operation; for example, with a spatial data set. Selection sets identified in the spatial data set may then be propagated to the related OLE DB table.

If the OLE DB table does not have a suitable field and you wish to enable Select by Attribute/relate the table to other data sources, add a new field.

Procedure

  1. Add a long integer field to the table and create a unique, not null index for it.
  2. Populate the field with integer values, making sure all values are unique and no fields are empty.
Note:
If the OLE DB table's data source is an Access table, the primary key field must be of data type AutoNumber for the field to be recognized as a pseudo ObjectID. An index is not required. 

Article ID: 000004463

Software:
  • ArcMap

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options