We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you a podcast all about Citrix Workspace, moving to the cloud, and analytics & intelligence. Episode 2 coming soon!Listen Now

x

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.

troyvw
troyvw asked
on
Medium Priority
985 Views
Last Modified: 2013-11-28
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

Comment
Watch Question

CERTIFIED EXPERT

Commented:
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.

Author

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.
CERTIFIED EXPERT
Commented:
I would expect the message to be correct.
' you and another user '  can mean either two users or one user with two processes.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.