Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Jan 2003
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Locked up database (97)

    We were running our database off of the Network when suddenly the network connection broke off. Access gave error messages that it could not find tables, etc. and then closed on the local machine. After re-establishing the Network connection, we are unable to get into the database because Access is saying that it is exclusively opened by ADMIN on (machine name). Any ideas on how to get back in or close the database out on the Network?

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

    Re: Locked up database (97)

    In the network directory with the backend there should be a file with the same name but extension of ldb. Try deleting that.

  3. #3
    New Lounger
    Join Date
    Jan 2003
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Locked up database (97)

    I'd already tried that and got a sharing violation message that prevented me from deleting it. I've also tried importing the tables into a new database and got the message about being opened exclusively.

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

    Re: Locked up database (97)

    I guess your backend is possibly corrupted. This exclusive open problem will likely stop you doing a repair from Access. There is however a utility, jetcomp.exe, that can repair databases without having to open them. That may get the problem sorted out.

  5. #5
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Emerald Beach, New South Wales, Australia
    Posts
    126
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Locked up database (97)

    <P ID="edit" class=small>(Edited by charlotte on 30-Jan-03 06:29. to activate link)</P>There is a product called WhoHasIT (for Novell) that displays any record locks held on a file and allows termination of the connection (assuming that you have sufficient network rights). There is also a NT version called WhoHasItNT .

    I used to use this all the time in my last contract when inexplicable locks on files occurred. It's also handy for providing info on who has a file open. There is a demo version available for download at http://www.gadgetfactory.com

    If your problem is a lock on the file this should get you out of trouble.

    Stewart

Posting Permissions

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