<div>
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.
</div>


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.

<div>
hmmm. &nbsp;It seems unlikely to me that this is what the problem was. &nbsp;The odds would be pretty low that two users where on the same records giving the nature of our system.
</div>


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.

<div>
<div class="content wysiwyg-content">
I have a module that run throught our application that when run generates the following error:<br />
<br />
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.<br />
<br />
I cannot not track down the a diirect cause. Any Ideas?<br />

<pre><code id="code-250533">Public Sub Save_The_Current_Record()    
  DoCmd.RunCommand acCmdSaveRecord
 End Sub
</code></pre>
</div>
</div>


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?

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.

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.