I have a small Access XP database with a main table (has a PK) and other tables that have FKs to it. The form is bound to the main table and its subforms are inside tabs which have a parent/child relationship to the main form.
Every now and then, the data input person gets this message:
"The Microsoft Jet database engine stopped the process because you and another user are attempting to change data at the same time."
This is simply not true. She's the only one on it even though the MDB is on the network.
When she clicks OK, the message continues to appear until all the textboxes on the subform display #Error. If she goes to another record and comes back, the data for those wacky records (form and subform) are still intact.
Any ideas of what causes that? Thanks in advance.
Michigan Dept. of Environmental Quality, Air Quality Division