Results 1 to 10 of 10
  1. #1
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Admin locked out (97)

    Admin locked out
    I am locked out of exclusive mode for my database but no one is using the file, how might I release the hold the LDB has over my database so I can retain exclusive access? I am assuming like a system crash or alt ctrl delete caused the LDB to remain on.

  2. #2
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Sacramento, California, USA
    Posts
    491
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Admin locked out (97)

    OK - I'll jump in with the obvious.
    Have you tried to delete the ldb?

  3. #3
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Admin locked out (97)

    That wouldn

  4. #4
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Sacramento, California, USA
    Posts
    491
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Admin locked out (97)

    Try it and let us know.

    <img src=/S/evilgrin.gif border=0 alt=evilgrin width=15 height=15>

  5. #5
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Admin locked out (97)

    Hi Arage

    If that dosen't get it see post: 135684

    John

  6. #6
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Admin locked out (97)

    My problem still exists and I am using the LDB viewer from MSN to verify that nobody else is in the mdb & it still won

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

    Re: Admin locked out (97)

    Did you delete the ldb? You'll need to provide more information. Are you opening this on a local machine or on a server? If the answer is server, there are two places to check, the server and your local machine. Also, there may be more than one lock file involved if you have a split front end/back end or if you have a reference set to another database or mde.

    I don't understand your remark about it being created with a particular workgroup. What does that have to do with trying to open the database exclusive? You may not be able to open the database at all if you don't use the correct workgroup, but I thought the issue was that you couldn't open it exclusive. <img src=/S/confused.gif border=0 alt=confused width=15 height=20>
    Charlotte

  8. #8
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Admin locked out (97)

    Well, when I tried to delete the LDB I got an error that the mdb was in use. So I waited until the users got out and when I tried to open it exclusively I continually got the error message that the mdb is in use by someone else. I downloaded the LDB viewer and looked at the file & it told me that no LDB was associated with the mdb. By the way, this mdb is a back end mdb that sits on the NT server. Hope you can help!

  9. #9
    3 Star Lounger
    Join Date
    Feb 2001
    Location
    NYC,USA,Earth
    Posts
    273
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Admin locked out (97)

    Check out this article. It refers to a Novell environment but I thought it might prove helpful.

    Click Here

    This one also may prove useful.

    Click Here Too

  10. #10
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Admin locked out (97)

    well, I dunno but the problem seems to have cleared itself as somehow I can now open the mdb exclusive & the only thing I did different was by clicking on the advanced button and then cancelling the action when I tried to open the mdb. This is so weird I hate it sometimes thanks for your help though!

Posting Permissions

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