Solved

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
6
14,569 Views
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)
0
Comment
Question by:dharnet
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 37

Assisted Solution

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

Author Comment

by:dharnet
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
0
 
LVL 15

Assisted Solution

by:dbase118
dbase118 earned 230 total points
ID: 22611334
Do you get these errors while entering data or when opening the database?
0
How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

 

Author Comment

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

Accepted Solution

by:
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:
http://support.microsoft.com/support/kb/articles/Q109/9/53.asp
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q273956
http://support.microsoft.com/default.aspx?scid=kb;en-us;306204

4) Access decompile:
http://www.granite.ab.ca/access/decompile.htm

5) Try a recovery tool / Table rescue
Table datarecovery:
www.mvps.org/access/tables/tbl0018.htm
Access recovery:
http://www.officerecovery.com/access/index.htm

6) Ask a company (will cost $$'s ! )
http://www.pksolutions.com/services.htm 
0
 

Author Comment

by:dharnet
ID: 22989727
satiffied !
0

Featured Post

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Help with DB2 Create store procedure query 4 130
querying from Excel and using multiple statements separated by semicolon 7 109
Catalog Index 9 131
MS Project - VBA 6 240
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…
"Disruption" is the most feared word for C-level executives these days. They agonize over their industry being disturbed by another player - most likely by startups.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
This video shows how to use Hyena, from SystemTools Software, to update 100 user accounts from an external text file. View in 1080p for best video quality.

738 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