I have an Access 2010 database and I open several of the tables in an excel spreadsheet. All the tables are set to "read-only" in Excel. If I open a custom form in Access, I always get a warning, "You do not have exclusive access to the database at this time. If you proceed to make changes, you may not be able to save them later." And indeed I cannot save changes. Does anyone have any suggestions to solve this as it is quite annoying. I can open the "straight" table in Access without problems and modify data but not an Access form. Suggestions?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Access Tables In Excel Cause Problem
- Thread starter MikeDBMan
- Start date
-
- Tags
- access table
