Access thinks another user is changing the same record, but isn't

[sck501]

Our Basic outline: We have a multi-user database (about 8-10 people at any time), which contains 50-60,000 records. We are using the back-end/front-end format with the front end on each workstation. Information is entered through forms set up as tabs.

The Problem: This problem does not occur on the primary tab, but on subsequent tabs--where new information is being added (as opposed to look ups or updating of information). On these pages, people entering data will get the message

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

The standard "OK" and "Help" buttons appear. After clicking "OK," the message appears again, and continues to appear until each field on the screen is an #ERROR#. The message only appears once the person has finished entering on that tab and is about to move on to a different record. And once we leave the record and come back, the #ERROR# entries are gone and the original information is back.

I'd like to get this problem solved because it is getting extremely aggrevating to the data-enterers, especially when the message pops up several times in a row.

Thank you!

 

[mrf1xa]

I suspect this is to do with the way your form is set up- I have had this before. What happens is that you create or edit a record using the main tab. While that record is locked on the main tab, you move to another tab which tries to amend the same record, hance the error.

I solved mine by adding a Me.Refresh (or Me.Requery, can't quite remember) which runs each time you change tabs, this updates the record and leaves it free to be accessed from the next tab.

Hope this helps Nigel
Didn't someone say work is supposed to be fun? They didn't have computers then I guess....

 

[cmmrfrds]

added 2 cents.

I believe, Nigel is correct in the assessment of what is happening. A tab control form treats all the forms on it like controls. So, when you open the tab control form all the data sources are actived much like controls on a regular form. As Nigel said, you need to make sure that record is not in edit mode on one tab while another tab is trying to use the same data source. If a user starts editing a record on any tab you need to make sure they move off that record before going to another tab. A refresh or requery, or any thing that causes the cursor to tab out of the edited record should do it.

 

[heartaccess]

Dear CMMRFRDS,

I too have a similar problem as sck501

While entering data into a grandchild subform, I receive the error message,

The Microsoft Jet Database Engine stopped the process because you and
another user attempted to change the same data at the same time.

After clicking through error, #error appears in the field.

It sounds like yourself and mrf1xa are familiar with a fix. I know for a fact that the database is not corrupt. Any and all assistance with this matter would be GREATLY appreciated.

 

[cmmrfrds]

The original problem seemed to indicate that a record from a table was in 2 updateable recordset. Probably open on a main form and the subform. The solution is to tab out of the record on the main form so that it is not locked and the subform can proceed with the update. If the recordset does not need to updateable on the main form then make it a read only recordset is another solution. Also, if you requery the main form the record will not still be locked.