Microsoft Jet database engine stopped Error?
A2k (9.0.4402) SR-1
I have a tabbed form for the master record with multiple sub forms for detail records attached.
One of the sub forms is single form and five other sub forms are continuous forms.
The record sources for all the forms are the individual tables.
The master record has a primary key lngBPermitID and the sub form tables each have a foreign key lngBPermitID.
Periodically when entering line item records in two of the sub forms with continuous records I get the following 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.
My only option is to click OK through the entire record, the message repeats for each field on the form with #error appearing in each field. When the error message finally stops, I can move the record selector to previous master record, then back to problem master record, select the tab that has the problem sub form and the data is there and correct.
This happens intermittently, it happens when there is only one person on the system.
Any clues on what
