Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page