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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Vicky - 20 Jul 2007 14:38 GMT

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

Reply to this Message

Baz - 20 Jul 2007 14:54 GMT

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?)

> Hi all,
> I have an access database which I cannot open. The message I get is "The
[quoted text clipped - 10 lines]
> Thanks in advance,
> -Vicky

Reply to this Message

Tony Toews [MVP] - 21 Jul 2007 00:29 GMT

>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

Signature

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/

Reply to this Message