We help IT Professionals succeed at work.

The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time.

skull52
skull52 asked
on
2,545 Views
Last Modified: 2012-05-07
ERROR: The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time.

I have a service tracking DB which is divided into 2 sections customer data which is pulled from linked SQL tables and is not editable and repair data which the user enters. I am getting the above error when more than one user is entering data into the Repair Information section which consists of 2 sub forms, I have changed the Record Locks property to Edited Record on all forms but still get the error, and I have also repaired and compacted the DB. The error does not appear if only one user is entering data. Any suggestions would be greatly appreciated. I have included a screen shot of the form.

ATIService01-Jul.-06-12.16.jpg
Comment
Watch Question

Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
skull52IT director

Author

Commented:
OK,
I changed the Record Locks property back to No Locks, split the database and gave each user their own copy, still I get the error whenever user 1 attempts to enter data even if user 2 only has the DB open and not entering data
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Bill RossProgrammer
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
skull52IT director

Author

Commented:
Thanks for all your help,  but the problem stemmed from one user using the edit parts table form as a look-up. That table is used to populated the parts used subform, so when he opened the form and tried to add the part it errored.
skull52IT director

Author

Commented:
ErezMor suggestion to split the database was a good one even though it did not fix the problem so I am awarding him the lions share of the point and splitting the rest among everyone else as they were good suggestions

Commented:
cheers mate!
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*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.