Database has been locked.

[tinsar]

I keep getting the error message. "The database has been placed in a state by user 'Admin' that prevents it from being opened or locked." This isn't a multi user system and I haven't placed any code in there that should lock it so where is this error coming from? Anybody have any clue?

 

[dustin]

Check to see if a *.ldb file is associated with the database file. If so, and the db is not open, then delete the ldb file.

If that doesn't work, try to create a new database and import all tables, queries, ect. into the new file.

I have never heard of that error, but it sounds similiar to others where the database is damaged by a shut down while a user is still connected to the database.

HTH,
Dustin