Database becomes inaccessible

  • Thread starter Thread starter sam.joseph74
  • Start date Start date
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
 
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
 
Back
Top