We help IT Professionals succeed at work.

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).  It is just me.

Papote
Papote asked
on
Medium Priority
687 Views
Last Modified: 2013-11-29
in Access (MDB) I have a table where I can Enter new data but if I edit or try to delete a table I get the error: "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)"
It is a linked table to SQL Server 2005.
There isn't anyone else on the server.

When I go to the Management Studio I can edit and delete. I've closed the management studio completely and updated the linked table, but it is only on that table.
Comment
Watch Question

Database Developer
CERTIFIED EXPERT
Commented:
Do you have a TimeStamp field added to your SQL Server table?
If not then add one.  (Then relink / refresh your linked table).
You don't need to bind anything to it in your forms etc.  It's just for internal use.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
It worked! Thanks.
I had originally imported my tables via Microsoft SQL Server Migration Assistant 2005 for Access and on some tables I noticed it had created the SSMA_Timestamp.
Is a Timestamp field required on ALL linked tables?
Leigh PurvisDatabase Developer
CERTIFIED EXPERT

Commented:
It's now considered good practice.  (For exactly this sort of updatability issue).
With direct server access, you shouldn't see it or need it to such an extent.
The SSMA does indeed create them by default.  (Though that can be a preference that is stopped).
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.