Unable to open database.

[sdawson]

Got the following message when I opened a database front end I'm working on.
There are no other users involved (stand alone PC).

"The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time."



Pointers please to get out of this.

 

[RuralGuy]

Is it an MDB file? Do you get the same results when you open while holding down a <SHIFT> key?

 

[sdawson]

Yep MDB and yep same when holding down shift key.

 

[RuralGuy]

Hmmm....
That does not sound right. Nothing should be executing when you hold down the shift key. Did you turn off the AllowByPassKey? You might try a /decompile and see if that corrects the problem.

 

[sdawson]

AllowByPassKey is on.

Tried the decompile with the following batch file:-

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE""C:\Documents and Settings\SDawson\My Documents\ACCESS\Production\production_new.mdb" /decompile

pause

Still no joy. Same message.

Plan B?

 

[RuralGuy]

Suggested plan B

 

[sdawson]

Now I know what backups are for!!!!

Thanks for trying.

 

[RuralGuy]

You're welcome. Try Allen's suggestions. They still might work.

 

[gemma-the-husky]

sometimes you can get stuck processes - does rebooting the pc help.

if not, perhaps you have locked a table or done something else with some startup code.

 

[sdawson]

gemma, rebooting not the answer.
Your comments re locked tables or startup code may prove to be correct if only I could get into it to find out! It was a new form I was working on the last time it was open.

Thanks

 

[sdawson]

Just ran the utility JetComp.exe in:-

http://www.everythingaccess.com/tutorials.asp?ID=Access-Database-Corruption-Repair-Guide#3

It created an new database that I am able to open but the query and the form I was working on when I was last in have disappeared!

Still at least I can get in and the query and form were only a days work. Doh.

 

[Fifer]

I had this same problem with one of my databsaes and it was down to a a .ldb file. I tried to delete this file and it wouldnt go until the next day, so I moved my db into a new file and it worked fine.