MS ACCESS 2002(XP) - locked out

[danielp0]

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.

 

[FrancisL]

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.

 

[JRGerry]

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