topic Editing 2007 MS Access .accdb using OLE DB connection? in Data Management Questions https://community.esri.com/t5/data-management-questions/editing-2007-ms-access-accdb-using-ole-db/m-p/443717#M25306 <HTML><HEAD></HEAD><BODY><SPAN>Can you edit a 2007 MS Access .accdb file format using the OLE DB connection?</SPAN><BR /><BR /><SPAN>I have made the connection using the following:</SPAN><BR /><BR /><A href="http://resources.arcgis.com/en/help/main/10.1/index.html#/Connecting_to_a_2007_Microsoft_Access_database_accdb_in_ArcGIS/005s00000024000000/">http://resources.arcgis.com/en/help/main/10.1/index.html#/Connecting_to_a_2007_Microsoft_Access_database_accdb_in_ArcGIS/005s00000024000000/</A><BR /><BR /><SPAN>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:</SPAN><BR /><BR /><UL><BR /><LI>No editable layers</LI><BR /><LI>Check to see that you have the appropriate permissions</LI><BR /></UL><BR /><SPAN>I created a .accdb file from scratch, so it is not read only. </SPAN><BR /><BR /><SPAN>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. </SPAN><BR /><BR /><SPAN>[ATTACH=CONFIG]25411[/ATTACH]</SPAN><BR /><BR /><SPAN>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?</SPAN><BR /><BR /><SPAN>Thanks,</SPAN><BR /><SPAN>Mike</SPAN></BODY></HTML> Fri, 21 Jun 2013 16:50:37 GMT MikeMacRae 2013-06-21T16:50:37Z Editing 2007 MS Access .accdb using OLE DB connection? https://community.esri.com/t5/data-management-questions/editing-2007-ms-access-accdb-using-ole-db/m-p/443717#M25306 <HTML><HEAD></HEAD><BODY><SPAN>Can you edit a 2007 MS Access .accdb file format using the OLE DB connection?</SPAN><BR /><BR /><SPAN>I have made the connection using the following:</SPAN><BR /><BR /><A href="http://resources.arcgis.com/en/help/main/10.1/index.html#/Connecting_to_a_2007_Microsoft_Access_database_accdb_in_ArcGIS/005s00000024000000/">http://resources.arcgis.com/en/help/main/10.1/index.html#/Connecting_to_a_2007_Microsoft_Access_database_accdb_in_ArcGIS/005s00000024000000/</A><BR /><BR /><SPAN>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:</SPAN><BR /><BR /><UL><BR /><LI>No editable layers</LI><BR /><LI>Check to see that you have the appropriate permissions</LI><BR /></UL><BR /><SPAN>I created a .accdb file from scratch, so it is not read only. </SPAN><BR /><BR /><SPAN>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. </SPAN><BR /><BR /><SPAN>[ATTACH=CONFIG]25411[/ATTACH]</SPAN><BR /><BR /><SPAN>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?</SPAN><BR /><BR /><SPAN>Thanks,</SPAN><BR /><SPAN>Mike</SPAN></BODY></HTML> Fri, 21 Jun 2013 16:50:37 GMT https://community.esri.com/t5/data-management-questions/editing-2007-ms-access-accdb-using-ole-db/m-p/443717#M25306 MikeMacRae 2013-06-21T16:50:37Z