Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Database already opened (97)

    I am trying to compact a database. I am getting the message, "database already opened exclusively by user "admin" on machine (my machine). Try again wihen database is available." I am the only one here and I don't have the database open. I have rebooted and everything. If the database is not open, what is the problem?

  2. #2
    2 Star Lounger
    Join Date
    Jun 2002
    Posts
    117
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Database already opened (97)

    Hi

    Do you share the DB with anyone else?

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Database already opened (97)

    Yes. It is on a share drive. There isn't anyone here but me and it is my PC asset tag that it is referring to.

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

    Re: Database already opened (97)

    Check the shared drive and see if there's an ldb file out there. If you can delete the ldb file, you should be able to open it exclusively. If you don't have adequate permissions to that share, that could be causing your problem.
    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
  •