View Single Post
 
Old April 21st, 2005, 01:26 PM
SerranoG SerranoG is offline
Friend of Wrox
Points: 4,007, Level: 26
Points: 4,007, Level: 26 Points: 4,007, Level: 26 Points: 4,007, Level: 26
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Lansing, Michigan, USA.
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default Incorrect Error Message Claims Multiple Users

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.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
__________________
Greg Serrano
Michigan Dept. of Environmental Quality
Air Quality Division