View Single Post
Old April 25th, 2005, 10:00 AM
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

I'm trying to track what triggers the behavior. Here's what I've noticed. When I enter a new record in the subform the first time, everything is OK. When I go to a new record on the main form and then enter the subform to add its details, I get the error about someone else having the database open. It's that second time. It's as though Access thinks I still have that previous record open for editing and a second person is now trying to edit it.

If the main form goes to a new record, the subform is linked to it via master/child of the primary/foreign key. The subform should be sitting there at a new record as well, but the error message is telling me it's still on the previous record even though the subform is blank.

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