I can successfully run some codes in a standard module and create recordsets
for an query. However, if I want to run this module again, I will always get
the above run time error and a msgbox "The database has been placed in a
state by User"Admin" on machine "xxxx" that prevents if from opened or
locked". I can only then run the module by shutting down Access and then run
This is very time consuming and annoying.
The only thing I found on the web was that something must be open. But I close everything I can think of. Please advise....
My code is attached in a text file....
errors on : conn.Open sConnString