C# and MS Access problem
Posted on 2014-01-07
I am developing a c# 2010 winforms application connecting to a networked MS Access 2003 database.
Occasionally I am seeing a message
"the database has been placed in a state by user 'admin' on machine 'ABCD'"
this doesn't happen too often and when it does, if I close the application and re-open it, it usually works ok.
The database is password protected and to my knowledge, I am the only person who knows it... the error appears when I have not got access open... so I can't see why there is a lock going on? None of the code allows users to modify the database structure, only the contents...
What should I look for?