Unanswered: "The database has been placed in a state by user XXX...." problem!
I have a database on a shared drive and its been working fine up to now. Hopwever, one of its users has started having trouble with adding new data. "The database has been placed in a state by user XXXthat prevents it from being opened of locked" appears when he tries to save a new entry.
The database is for recording Project File entries...so we have say Projects A,B and C, and each project may have 100 entries. The user in question can save new entries to Projects A,B and C...but when he tries to add a new project, Project D to the database thats when the error message pops up.
I've tried saving a number of test entries on various computers in our office and his is the only one which won't save the entry, so i presume the problem is with his computer.
On the machine that XXX uses (or first used it when encountering problem), have XXX reboot PC. Then have him open and close the mdb; this should release the LDB (or lock) file. Otherwise, test XXX using mdb on an NT(?) loggin other than his. This will indicate his NT id or mdb as the fault.