• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 878
  • Last Modified:

Microsoft Access mde file: cannot open because of error message

Hi,

I cannot open a MS Access mde file. I get the following error message whenever I try to open it:

The Microsoft Access database engine stopped the process because you and another user are attempting to change the same data at the same time. (Error 3197)

I cannot get into the file at all -- to run a repair or even to save the data. Can you please help
0
Ucaihc
Asked:
Ucaihc
  • 3
  • 2
  • 2
1 Solution
 
MINDSUPERBCommented:
Ucaihc,

Have a check with this KB from Microsoft. It might solve your problem.

http://support.microsoft.com/default.aspx?scid=kb;en-us;279334&Product=acc

Sincerely,

Ed
0
 
UcaihcAuthor Commented:
Thank you. But my question is, how can I run any of these utilities if I cannot even open the database?
0
 
MINDSUPERBCommented:
Ucaihc,

This is part of the KB of that link.

If the corruption involves being unable to open the class module of a form or a report, or the design view of a module, you may want to try the /decompile command line switch. It is strongly recommended that you make a back-up copy of the database before attempting this method. The following is a sample command with the /decompile switch, wherein MSAccess.exe is in its default location and the database DB1.mdb is in the C:\ folder:
C:\Program Files\Microsoft Office\Office\MSAccess.exe /decompile C:\DB1.mdb

Ed
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
UcaihcAuthor Commented:
Thanks, but I can't even open the database itself. Will the decompile command line work in this case?
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
". Will the decompile command line work in this case?"
Not likely, because that requires opening the database.

1) Try this, but longshot:
Possibly this might help:

http://support.microsoft.com/kb/295334
One note:  Be sure you specify a *different* mdb name for the Destination text box.

JetComp is sort of Compact and Repair on steroids ... sometimes works when C&R (especially the Repair part of C&R) fails.  

2) Last resort ...
http://www.everythingaccess.com/accessdatabaserepair.htm

Wayne can most likely fix this ...

mx
0
 
UcaihcAuthor Commented:
JETCOMP did not work. I look at the last resort link you sent me. How much does it cost?
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Cost?  Sorry, I don't know.  Send the email.  Please note that they are in the UK  GMT 0 or GMT+1 ...
You will get a quick response ...

mx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now