Runtime Error ‘3188’

Topic

New Reply

I’m trying to troubleshoot a database that was working fine a couple of days ago. Now when I go in and access a test record and click on one of the option boxes I have, I get a “Runtime error 3188 – Could not update – currently locked by another session on this machine”
This makes no sense to me. I have nothing else running. No one else is on the database.
Is there someone who might be able to shed some light on this for me?

Reply | Quote

Replies

Check for an LDB file with the same name as the database file. Sometimes these lock files will “stick” and not get destroyed because of an abnormal end to the program. If you delete the LDB, the error message should disappear. It’s also possible to get this message because of something you’re doing, like opening two sessions of the same database at the same time. Since this only started recently, that sounds like an unlikely possibility, but you should always check that first when you get this error.

Reply | Quote

Charlotte
I checked everything I knew… that’s what I thought was so weird. How would I know if I had another session open on my own computer? Access opens .ldb and then closes them. If I’m in Access then of course the .ldb will be there, but only one .ldb was there. No matter how many people are in the database only one .ldb is there. ???

Reply | Quote

Yes, only one mdb file is present regardless of how many people simultaneously use the database and normally goes away when the last person closes the database.

Normally, if you had a second session open then you’d see that in your task bar. To make absolutely certain you could always log off and back on (or reboot) again (never needed to with Access, but I’ve needed to with Word before).

If you know no one else is using the database, delete the mdb file and try again. If it is still doing it, then something is corrupted.

Reply | Quote

Umm — you mean delete the ldb file right ? Don’t delete the mdb file unless you’ve got a backup copy !

Reply | Quote

All the locks for all the users of a single database are placed in the same ldb file. On your local machine, you’ll have an ldb file for each database you have open, unless of course, you’ve opened the same mdb twice. Your best bet is to use the Task Manager to see if you have multiple Access sessions running.

Reply | Quote