Page 1 of 2 12 LastLast
Results 1 to 15 of 24

Thread: Locking problem

  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Indiana, USA
    Posts
    107
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Locking problem

    We use Access 97 SR-2. Four users work in a database. They have been working in it for a few months. All of a sudden, last week, they started getting the following error messages:

    Couldn't save; currently locked by user "Admin" on machine '45'

    The Save operation failed.

    Out of memory.

    All four users have made sure that No Locks is checked.

    We also have four other users using a different database that have a similar problem.

    Any idea what is going on?

    Thanks.

  2. #2
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Altnau, Thurgau, Switzerland
    Posts
    447
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Locking problem

    Have you tried a repair on the back end data database?

  3. #3
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Indiana, USA
    Posts
    107
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Locking problem

    Yes, Andy. We ran a database repair and compacted it.

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

    Re: Locking problem

    Check the systems for orphan .ldb files and delete them. Regarding compact/repair - have you run Jetcomp.exe ?

  5. #5
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Indiana, USA
    Posts
    107
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Locking problem

    OK, we will look for .ldb files. We have not done a Jetcomp.

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

    Re: Locking problem

    For future archive searchers, an excerpt from MS KB re: Jetcomp <font color=blue>JETCOMP.exe does not attempt to open and close the database before compacting, and may therefore be able to recover some databases that the Microsoft Access compact utility and the CompactDatabase method cannot.

    </font color=blue> Further information is available Here with a link to download Jetcomp.exe

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

    Re: Locking problem

    Have you made any design changes to either of these databases recently? Out of memory messages can be caused by repeatedly running blocks of code that create but do not destroy object variables (i.e., Dim dbs as Database, but no Set dbs = Nothing).

    Have you applied any of the Jet service packs to any of the machines? A difference in Jet service packs between machines can cause all sorts of odd behavior.
    Charlotte

  8. #8
    Star Lounger
    Join Date
    Jan 2001
    Location
    Bethel, CT, USA
    Posts
    58
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Locking problem

    I had a similar problem with a single database shared on a network drive. When a design change was made it could not be saved until all users had closed out. Until the database was free, I received error messages identical to yours.

  9. #9
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Indiana, USA
    Posts
    107
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Locking problem

    Charlotte, I don't think there have been any design changes or updates of jet service packs. This database has very little code.

    Brian, I know what an .ldb file is but am not sure what "orphan" means. The network folder only contains one .ldb file that carries the same name as the database. On the users c: drive, there are a lot of .ldb files, but none have the same name as the network copy. From what I have read, the .ldb file is created each time the database is loaded (since Jet 3.0). Could it be that the .ldb files on their c: drives are interfering with the network copy? I have a feeling that they don't. Anyway, let's not give up. There has to be a reason for this behavior.

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

    Re: Locking problem

    When closed correctly the ldb disappears like a nice temporary file should. Sometimes, when Access is not properly closed or the os crashes, the ldb (locked database) file will remain on the system. That can cause problems [img]/w3timages/icons/frown.gif[/img] There should only be one ldb per Access session. Close the application and scout for an ldb. If Access isn't running, and there are ldb files <font color=red>nuke em' they're orphans, don't belong to anybody </font color=red> [img]/w3timages/icons/alien.gif[/img]

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

    Re: Locking problem

    You may run into an ldb file that refuses to let you delete it. In that case, log out of Windows and back in again, and you should be able to delete the little devil!
    Charlotte

  12. #12
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    352
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Locking problem

    Make sure the users are all using their own copies of the front end, otherwise if one decides to, say, bold the text in a control, they will lock everyone else out!
    David Grugeon
    Brisbane Australia

  13. #13
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Indiana, USA
    Posts
    107
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Locking problem

    Brian, in what location is the .ldb file created? The database resides on a network server in a particular folder. When a user opens the database, is the .ldb file created in the same folder? If another user opens the same database, is an .ldb file created for the new user?

    I have opened the .ldb files using Notepad. It contains the name of a machine and Admin or admin. It may contain one machine name or more. Could there be a conflict with the machine names/Admin and admin in the .ldb file?

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

    Re: Locking problem

    Hi Lonnie:
    First, a little background:
    <hr>A locking information (.LDB) file is used to control multi-user locking in Microsoft Access tables. In a multi-user environment, each user who opens the database has an entry in this file. Microsoft Access uses this information to tell which records are locked in a database, and who has them locked, to prevent possible file contention errors and database corruption by multiple users. The file is created automatically when you open a Microsoft Access database (.MDB) file. You can delete a database's .LDB file only when no users have the database file open. <hr>
    In answer to your question, the .ldb file is created in the folder where the .mdb file resides. No matter how many users access the .mdb, only one .ldb should be created. A machine name Admin should cause no conflict. Are you running a Split Database Back End and Front Ends ? If you are, there will be an .ldb on the users machine as well as one on the machine holding the back end. If you haven't split your database you should seriously consider it.

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

    Re: Locking problem

    FYI, There is only one ldb file created for a database, regardless of the number of users who are in it, and that is in the same folder as the database. After the first user, the information for other users goes into the same ldb. The Admin user is the default, and if Access security has not been implemented, everyone logs in as Admin. The entries are machine specific, so there is no problem with multiple admin users.
    Charlotte

Page 1 of 2 12 LastLast

Posting Permissions

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