uwlchemist
New Member
- Joined
- Aug 29, 2009
- Messages
- 38
I have a number of template workbooks that all connect to one database to refresh certain information. I use a refresh all command in the on open event of the workbook. The issue I am having is that when any of these workbooks are open, it locks the access database (creates the .laccdb file) making it so that I cannot make structural changes to the database. Is there a way to refresh the data from the database, and then release the database so it can be opened exclusively?