Unlocking Tables not used by anyone while other users are using the DB
Posted on 2011-02-16
I have a DB used by 20 users at any given time. There is an administrative routine that drop and creates tables. Users have no access to these tables.
When users are in the DB though I get the following message:
"You tried to lock table '900 Available Hours Prep 1a' while opening it, but the table cannot be locked because it is currently in use. Wait a moment, and then try the operation again"
I tried with the following code but I get the same message:
DoCmd.DeleteObject acTable, "900 Available Hours Prep 1a"