Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Access Locked my file

Discussion in 'Information Technology' started by About Face Intern, Oct 29, 2005.

  1. About Face Intern

    About Face Intern
    Expand Collapse
    Guest

    I was working on a database and my computer froze. When I rebooted the
    computer and tried to open the file I'd been working on, access said "The
    database has been placed in a state by user 'Admin' on the machine "willaft'
    that prevents it from being opened or locked." I can't even access the file
    from the computer I was working on it from, or from anywhere else. If anyone
    has any idea on how I can unlock this file and get access to it, please let
    me know. Thanks very much
     
  2. Loading...


  3. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    About Face Intern wrote:
    >I was working on a database and my computer froze. When I rebooted the
    > computer and tried to open the file I'd been working on, access said
    > "The database has been placed in a state by user 'Admin' on the
    > machine "willaft' that prevents it from being opened or locked." I
    > can't even access the file from the computer I was working on it
    > from, or from anywhere else. If anyone has any idea on how I can
    > unlock this file and get access to it, please let me know. Thanks
    > very much


    It may be several things but I suggest taking a look at the directory
    where the database (MDB or MDE) file is located. See if you don't have a
    MYFILENAME.LDB file. If so delete it and you should be ready to go.
    Rebooting with a database open often leaves Access thinking you are still
    there. Deleting the LDB file clears its memory.

    --
    Joseph Meehan

    Dia duit
     
  4. MacDermott

    MacDermott
    Expand Collapse
    Guest

    Compacting/Repairing the database often helps with this.
    But make a backup copy first! In odd cases, the compact/repair may make the
    problem worse.

    "About Face Intern" <About Face Intern@discussions.microsoft.com> wrote in
    message news:07CBA026-7EB0-4946-8F75-4F52C4AE39A1@microsoft.com...
    > I was working on a database and my computer froze. When I rebooted the
    > computer and tried to open the file I'd been working on, access said "The
    > database has been placed in a state by user 'Admin' on the machine

    "willaft'
    > that prevents it from being opened or locked." I can't even access the

    file
    > from the computer I was working on it from, or from anywhere else. If

    anyone
    > has any idea on how I can unlock this file and get access to it, please

    let
    > me know. Thanks very much
     
  5. Tony Toews

    Tony Toews
    Expand Collapse
    Guest

    "About Face Intern" <About Face Intern@discussions.microsoft.com>
    wrote:

    >I was working on a database and my computer froze. When I rebooted the
    >computer and tried to open the file I'd been working on, access said "The
    >database has been placed in a state by user 'Admin' on the machine "willaft'
    >that prevents it from being opened or locked." I can't even access the file
    >from the computer I was working on it from, or from anywhere else. If anyone
    >has any idea on how I can unlock this file and get access to it, please let
    >me know.


    For more information on corruption including possible causes,
    determining the offending PC, retrieving your data, links, official MS
    KB articles and a list of vendors who state they can fix corruption
    see the Microsoft Access Corruption FAQ at
    http://www.granite.ab.ca/access/corruptmdbs.htm

    Tony
    --
    Tony Toews, Microsoft Access MVP
    Please respond only in the newsgroups so that others can
    read the entire thread of messages.
    Microsoft Access Links, Hints, Tips & Accounting Systems at
    http://www.granite.ab.ca/accsmstr.htm
     
  6. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    MacDermott wrote:
    > Compacting/Repairing the database often helps with this.
    > But make a backup copy first! In odd cases, the compact/repair may
    > make the problem worse.
    >
    > "About Face Intern" <About Face Intern@discussions.microsoft.com>
    > wrote in message
    > news:07CBA026-7EB0-4946-8F75-4F52C4AE39A1@microsoft.com...
    >> I was working on a database and my computer froze. When I rebooted
    >> the computer and tried to open the file I'd been working on, access
    >> said "The database has been placed in a state by user 'Admin' on the
    >> machine "willaft' that prevents it from being opened or locked." I
    >> can't even access the file from the computer I was working on it
    >> from, or from anywhere else. If anyone has any idea on how I can
    >> unlock this file and get access to it, please let me know. Thanks
    >> very much


    I understand your pain, sorry I don't have a suggestion.

    --
    Joseph Meehan

    Dia duit
     

Share This Page