The database has been placed in a state by user admin on XXX that prevents it from being opened or locked
Posted on 2010-04-05
I have an ASP website running off an MS Access database. A few days ago, I began experiencing this error message frequently while loading pages that usually work:
"The database has been placed in a state by user admin on XXX that prevents it from being opened or locked"
I have downloaded the database a few times when this has happened to try to see if there are any problems, but can't see any. One thing I did notice though was that there was always an .ldb file on the server when I went to get the database - normally there would just be the main .mdb file.
If I click refresh, usually the page will reload correctly and I can carry on, although I'll sometimes get the same error a few pages later.
Is this a case of having outgrown the MS Access platform? I've been searching Google and EE, but most posts on this seem to be relating to network usage scenarios rather than dynamic websites.
Does anyone know what is going on and how I can solve this?