I created a split Access 2010 database with a back-end for just tables and the front end with queries and forms. The front-end is linked using an OLE DB connection to ArcGIS, which works fine. When the database connection is connected I am unable to modify my forms but I can update and create queries.
Could this be an issue with having the forms bound to my table query? or is it because I am using a table query for the form? I don't know how to update my table records from the form without it being bound to the table. I am also using the Microsoft Office 12.0 Access Database Engine OLE DB Provider.
This is a multiple user database and other users maybe linking this to ArcGIS and might also need to make modifications.