Solved

Microsoft Access mde file: cannot open because of error message

Posted on 2010-09-14
7
859 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
How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

 

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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

It is a common problem that often server suffers from the lack of space on system volume. Old servers or new ones from vendors come with preformatted small volume - 5-6GB in total and after installing updates or applications the free space on system…
I use more than 1 computer in my office for various reasons. Multiple keyboards and mice take up more than just extra space, they make working a little more complicated. Using one mouse and keyboard for all of my computers makes life easier. This co…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
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…

706 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now