Database becomes inaccessible

S

sam.joseph74

“The Microsoft Jet database engine stopped the process because you an
another user are attempting to change the same data at the same time”

The error message appears every time when attempts to mount th
database. I have very important data in it so please tell me what to d
to save that data
 
A

Arvin Meyer [MVP]

You haven't told us much about your database, so all I can give is general
answers. Make sure that the error is not correct by setting your options to
Shared, rather than Exclusive. Do a Compact and Repair on a copy. And BTW,
always make sure that you backup. If there's still a problem:

First, always work on a copy of the database. Working on the original may
make it impossible for a repair service to fix it.

Decompile your database:
http://www.trigeminal.com/usenet/usenet004.asp

Download a copy of JetComp.exe:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;273956

Try backing up your forms as text with the undocumented SaveAsText
LoadFromText functions:

http://www.datastrat.com/Code/DocDatabase.txt

Also have a look at the Microsoft KB article:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;209137

Then have a look at Tony Toews' Access Corruption FAQ at:

http://www.granite.ab.ca/access/corruptmdbs.htm

for some suggestions. Unfortunately, some corruption cannot be fixed - you
may need to create a new database, import what can be salvaged, and recreate
the rest.

Although it's a paid service, Peter Miller does an outstanding job of saving
corrupt databases. Try this URL:

http://www.pksolutions.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top