• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 591
  • 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

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

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