• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 630
  • Last Modified:

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.

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.
0
Papote
Asked:
Papote
  • 2
1 Solution
 
Leigh PurvisDatabase DeveloperCommented:
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.
0
 
PapoteAuthor 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?
0
 
Leigh PurvisDatabase DeveloperCommented:
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).
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now