Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Dec 2004
    Location
    Ontario, Canada
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Runtime Error '3188'

    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?

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Runtime Error '3188'

    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.
    Charlotte

  3. #3
    New Lounger
    Join Date
    Dec 2004
    Location
    Ontario, Canada
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Runtime Error '3188'

    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. ???

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Edmonton, Alberta, Canada
    Posts
    326
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Runtime Error '3188'

    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.

  5. #5
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    London, Ontario, Canada
    Posts
    437
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Runtime Error '3188'

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

  6. #6
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Runtime Error '3188'

    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.
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •