Can you edit a 2007 MS Access .accdb file format using the OLE DB connection?
I have made the connection using the following:
I can add and view the tables from this file in ArcMap, but when I try to start an edit session on this table, it errors out with the follwoing 2 errors:
- No editable layers
- Check to see that you have the appropriate permissions
I created a .accdb file from scratch, so it is not read only.
Under the Advanced tab in the Data Link Properties for the OLE DB connection, I have set the ReadWrite option check mark and unchecked the rest and I am still unable to edit this table in ArcMap.
Click image for larger version Name: OLE_DB_Advanced.jpg Views: 14 Size: 44.7 KB ID: 25411
There isn't much documentation on the OLE DB connection in the help file other than how to connect as posted above. Can anyone point out what I may be doing wrong?