Access error 3197 and JETCOMP.exe error "Error compacting database

V

Vicky

Hi all,
I have an access database which I cannot open. The message I get is "The
Microsoft Jet database engine stopped the process because you and another
user are attempting to change the same data at the same time."

I make some search and found this problem is due to a corrupted database. I
tried compacting it using both the Access tool and the JETCOMP.exe. The first
option gave me the same error message. JETCOMP gave me the "Error compacting
database".

Can anyone help me on this please?

Thanks in advance,
-Vicky
 
B

Baz

Your database is badly corrupted. If Jetcomp can't fix it then it's
probably toast, but you could first try creating a new, empty database and
importing all the objects from the corrupted one. Even if it doesn't work
completely, you might at least be able to find out which object is causing
the problem and rescue everything except that one object.

If that doesn't work, you'll probably need to restore from a backup (you do
have a backup, right?)
 
T

Tony Toews [MVP]

Vicky said:
Can anyone help me on this please?

There area few other things to try but your chances of success are
not that great.

For more information on corruption including possible causes,
determining the offending PC, retrieving your data, links, official MS
KB articles and a list of vendors who state they can fix corruption
see the Microsoft Access Corruption FAQ at
http://www.granite.ab.ca/access/corruptmdbs.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 

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