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

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

"Vicky" <(E-Mail Removed)> wrote in message
news:EAEA6A43-E30D-4C10-BCCE-(E-Mail Removed)...
> 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

Vicky <(E-Mail Removed)> wrote:

>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/