Database locked or placed in a state by Admin when saving form with ADO

M

Michael Edwards

I can't figure this one out. In Access 2000 mdb, if the user performs a File
/Save on a form with code performing ADO (which really should never occur),
and then tries to run the code performing ADO, a message pops up:

"The database has been placed in a state by user 'Admin' on machine 'X' that
prevents it from being opened or locked."

none of the ADO stuff executes properly. The only way to make the mdb usable
again is to close it and re-open it.

What's up with this? Am I doing something or not doing something? Any input
would be appreciated.
 
Top