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)

Posted on 2008-09-30
Last Modified: 2013-11-15
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)
Question by:dharnet
  • 3
  • 2
LVL 37

Assisted Solution

momi_sabag earned 20 total points
ID: 22609233
what is the question?

Author Comment

ID: 22609879
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)

This error can occur in a multiuser environment.

Another user has changed the data you are trying to update. This error can occur when multiple users open a table or create a Recordset and use optimistic locking. Between the time you used the Edit method and the Update method, another user changed the same data.

To overwrite the other user's changes with your own, execute the Update method again.

Can you give me the step by step solution resolve this
LVL 15

Assisted Solution

dbase118 earned 230 total points
ID: 22611334
Do you get these errors while entering data or when opening the database?
3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.


Author Comment

ID: 22611409
While Openning the.MDB databse access file.
LVL 15

Accepted Solution

dbase118 earned 230 total points
ID: 22613909
Sounds like you could have gotten some corruption in your file. There are many reasons why it could have happened but most likely you will need to try some recovery options.

First you can try creating a blank database and importing the objects into a fresh database. If that does not work, I would recommend looking at the following recovery options outlined by nico5038 in many previous posts on corruption.

1) Create a backup of the corrupt database. (Just in case of)

2) Create a new database and use File/Get external data/Import to get all objects of the damaged database.

3) Try Microsoft repair solutions:;en-us;Q273956;en-us;306204

4) Access decompile:

5) Try a recovery tool / Table rescue
Table datarecovery:
Access recovery:

6) Ask a company (will cost $$'s ! ) 

Author Comment

ID: 22989727
satiffied !

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
remove db2tschg.his file 1 125
Terminology:  DevOpts 2 108
Assignment Owner for Resource grayed out in MS Project Professional 2013 1 140
iSeries DB2 SQL - Query Missing Value 10 67
At the office, we’ve started to get serious about organizing what we’re doing. I mean, it was getting to the point where every time I received a phone call, it began with “I know you’re really busy, but…” My boss was taking tasks away from me left a…
Online collaboration is quickly becoming embedded in the workplace, and its benefits are tangible. See what the current landscape looks like and what the future holds for collaboration tools and the future of work.
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

920 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

15 Experts available now in Live!

Get 1:1 Help Now