Results 1 to 9 of 9
  1. #1
    Join Date
    May 2003
    Location
    UK
    Posts
    233

    Unanswered: Placed in a State by user 'Admin'

    I have a MS Access front end that will not let me open it saying that

    The database has been placed in a state by user 'Admin' on machine 'machine name' that prevents it form being opened or locked.

    The machine is the machine I am using. I am gaining access thru a VPN.

    I can see the Acces.Lockfile9 but do not know how to remove this.

    Can anyone help me first release it and tell me why this problem has come about. This has not happened before yet has happened 3 times today.

    There are no passwords set on the database.

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713

    Re: Placed in a State by user 'Admin'

    Originally posted by HelpMePlease
    I have a MS Access front end that will not let me open it saying that

    The database has been placed in a state by user 'Admin' on machine 'machine name' that prevents it form being opened or locked.

    The machine is the machine I am using. I am gaining access thru a VPN.

    I can see the Acces.Lockfile9 but do not know how to remove this.

    Can anyone help me first release it and tell me why this problem has come about. This has not happened before yet has happened 3 times today.

    There are no passwords set on the database.
    Close out access. Run Task manager and verify no other instances are running. Delete the lockfile. Go about your merry way ...

  3. #3
    Join Date
    May 2003
    Location
    UK
    Posts
    233
    I have run the Task Manager and there are no programs running I am still unable to remove the locked file.

    Any further help appreciated

  4. #4
    Join Date
    Feb 2004
    Location
    Dorset UK
    Posts
    147
    I am still unable to remove the locked file

    You cant delete the .ldb file ?



    Get your IT department to find out who is in the database, they may have it opened exclusively.

    Then once you have managed to get them out, you should be able to 'go about your merry way - again'

    Dont forget to have a go at the user who has done this, I cannot stand 'users' who think they are so important they need exculsive rights. Only a programmer would need this...
    Regards

    Ken.

  5. #5
    Join Date
    Jan 2004
    Location
    Jersey, UK
    Posts
    108
    In addition, here's some very useful free software that checks an mdb file and tells you who's using it. It's called ldbview and is contained in the jetutils package at this link:

    http://support.microsoft.com/default...NoWebContent=1


    Regards - Andy

  6. #6
    Join Date
    May 2003
    Location
    UK
    Posts
    233
    I know who is using it - it is myself.

    But I am not logged in. I connected through a VPN that lost its connection.

    Will this software allow me to delete the file as well.

    Thanks

  7. #7
    Join Date
    Jan 2004
    Location
    Jersey, UK
    Posts
    108
    Originally posted by HelpMePlease

    Will this software allow me to delete the file as well.

    No, it won't allow you to delete the file and I have no idea how to solve your problem... sorry and good luck!

  8. #8
    Join Date
    May 2003
    Location
    UK
    Posts
    233
    Ok thanks Randy,

    Ill let you know if I sort it out.

    Cheers

  9. #9
    Join Date
    Nov 2003
    Location
    Sussex, England
    Posts
    404

    Unhappy Locked out

    I've had this problem before - it's usually network related. In all the past instances we have hed to wait for about a day for the .ldb file to become accessible. You network administrator would normally be able to delete it, but I'm guessing the VPN is messing up that aspect of it.

    I never opened a database as exclusive when this happened to me, the only way round it I was able to find was to open a blank database, copy everything into it and then write it back over the original, when I could access it again. Not an ideal solution

Posting Permissions

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