0

enter image description hereI have made an MDB Access Connection by linking the Excel file with the Access one, but when I looked at the result in ArcMap the feature class table does not have an Object ID on it. I tried to export the file in shapefile in order to get Object ID on it.

How can we keep the connection with the MDB Access connection with the new feature class in order to update the data directly from Excel table to be displayed and updated directly on ArcMap?

1 Answer 1

2

See the following section (2nd) the ArcGIS webpage:

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. For more information about working with tables that lack Object IDs, see About ObjectID fields.

And for more information on the ObjectID:

Instead of trying to connect a existing .mdb database, I would also suggest to look into "personal geodatabases", which essentially is a .mdb database but then with edit functionality. However, they do come with restrictions (such as a max. 2gb limit). Depending on your use-case, it might be a good fit or not.

4
  • 2
    Please cut&paste the text from the documentation instead of using an image (which is not legible on all devices and can't be indexed for text search).
    – Vince
    Apr 11, 2021 at 10:50
  • Many thanks for your prompt replay, thus my concern is how we can Keep the connection made by access mdb, the way that i can perform certain operation and queries on the attribute table shown on arc map, i tried to export the table as shapefile i end up with one with ID object on it but i couldnt make the data linked again
    – Mounir AB
    Apr 11, 2021 at 13:32
  • Thank you @Vince edited my answer as you suggested.
    – PGerrits
    Apr 13, 2021 at 9:47
  • @mounirAB , you can also have a look at gisquirrel.com/home . They offer an add-in for Arcmap that can do many of the things you would like to have, for MS SQL server but probably also .mdb . They offer free licences for education and trial versions are available as well.
    – PGerrits
    Apr 13, 2021 at 9:53

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.