×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

MS ACCESS 2002(XP) - locked out

MS ACCESS 2002(XP) - locked out

MS ACCESS 2002(XP) - locked out

(OP)
   Hi there
I've got myself into a perculiar proble and I'm suprised it's not more common as it's quite easy to get caught. While running a database the computer rebooted, and did not allow to reopen it, because it claims that me and another user are trying to connect to it. (which is not the case)  what is the case though is (in my assumption) that ACCESS wrote something to the file that lets Access know that it is being used and therfore locks it for other users. Since the application did not exit properly, this byte did not get changed back to the original state and therfore it assumes that someone is still connected to it.    I'm suppried this doesn't happen more often.
  anyhoo - I looked up the JetUtils, but they were not very helpfull as they rely on a .ldb file that the database does not have.

    anyone else find a way to go around this ... I've spent way too much time already in hexedit comparing two DB's and don't want to go on like this for much longer.

RE: MS ACCESS 2002(XP) - locked out

If your PC rebooted but the Access DB was on a server you can get this. Sometimes the server must be rebooted too.
The information on who is logged on is in the LDB file.
You might also try copying the file to a new folder and then running compact and repair on it.

RE: MS ACCESS 2002(XP) - locked out

Just a word to say you are not alone. The problem has been around since version 2.0. Workaround: Create a new empty database; import all your objects into it; and everything should be functional again...

Good Luck!
JR

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources