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.

Posted on 2009-02-11
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.
Question by:Papote
    LVL 44

    Accepted Solution

    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.

    Author Comment

    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?
    LVL 44

    Expert Comment

    by:Leigh Purvis
    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).

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
    I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
    Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
    In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

    729 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

    18 Experts available now in Live!

    Get 1:1 Help Now