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

Error 3197 The microsoft access database engine stopped the process because you and another user are attempting to change the same data at the same time.

I have a module that run throught our application that when run generates the following error:

Error 3197 The microsoft access database engine stopped the process because you and another user are attempting to change the same data at the same time.

I cannot not track down the a diirect cause. Any Ideas?
Public Sub Save_The_Current_Record()    
  DoCmd.RunCommand acCmdSaveRecord
 End Sub

Open in new window

0
troyvw
Asked:
troyvw
  • 2
1 Solution
 
peter57rCommented:
This usually points to a situation where you have the same table open in two different objects (eg two forms) and are editing both or you are editing the same record in code as you have open in your form.
0
 
troyvwAuthor Commented:
hmmm.  It seems unlikely to me that this is what the problem was.  The odds would be pretty low that two users where on the same records giving the nature of our system.
0
 
peter57rCommented:
I would expect the message to be correct.
' you and another user '  can mean either two users or one user with two processes.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

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