Solved

Microsoft Access mde file: cannot open because of error message

Posted on 2010-09-14
7
861 Views
Last Modified: 2013-12-01
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
Comment
Question by:Ucaihc
  • 3
  • 2
  • 2
7 Comments
 
LVL 19

Expert Comment

by:MINDSUPERB
ID: 33673260
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
 

Author Comment

by:Ucaihc
ID: 33673618
Thank you. But my question is, how can I run any of these utilities if I cannot even open the database?
0
 
LVL 19

Expert Comment

by:MINDSUPERB
ID: 33674528
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
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 

Author Comment

by:Ucaihc
ID: 33674696
Thanks, but I can't even open the database itself. Will the decompile command line work in this case?
0
 
LVL 75
ID: 33675218
". 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
 

Author Comment

by:Ucaihc
ID: 33675289
JETCOMP did not work. I look at the last resort link you sent me. How much does it cost?
0
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Access MVP) earned 500 total points
ID: 33675328
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

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A while back when OPSMGR 2012 was released we were very excited about getting it into our environment and upgrading our 2007 implementation,  we started our planning and we then proceeded with our implementation. All went as planned & our system …
The article will include the best Data Recovery Tools along with their Features, Capabilities, and their Download Links. Hope you’ll enjoy it and will choose the one as required by you.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question