I have a large registry of about 260,000 records in microsoft access with data on land quarter sections. This data was to much for ArcGIS 10.2 to handle directly, so I created a Microsoft Jet 4.0 OLE DB connection to the database and added the query table I greated in Access.
Now I want to relate the table with the quarter section feature class (polygons of all the quarter sections). With this, I need to be able to select one or more quarter sections on the feature class and bring up all the related data from my access table.
However, ArcGIS help states that
Because OLE DB connections do not have an ObjectID field, which is a field maintained by ArcGIS that guarantees a unique ID for each row in the table, you won't be able to perform certain operations in ArcMap. These include selecting the features in the layer on the map in any way, applying a definition query, creating full relates, or editing the attributes. See About ObjectID fields for more information about working with tables that lack Object IDs.
So I cannot relate a table from the OLE connection with ArcGIS due to lack of ObjectID.
Does anyone know a work around or a way to create the ObjectID so I can select related records from my large access dataset based on selected quarter sections on my feature class.