BrokenLegMike

Editing 2007 MS Access .accdb using OLE DB connection?

Discussion created by BrokenLegMike on Jun 21, 2013
Can you edit a 2007 MS Access .accdb file format using the OLE DB connection?

I have made the connection using the following:

http://resources.arcgis.com/en/help/main/10.1/index.html#/Connecting_to_a_2007_Microsoft_Access_database_accdb_in_ArcGIS/005s00000024000000/

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.

[ATTACH=CONFIG]25411[/ATTACH]

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?

Thanks,
Mike

Attachments

Outcomes