MS Acess Problem w multiple forms off a single data table

[ghadley_00]

Hi,

I have multiple forms that edit fields in a single table, occasionally,
while I have 2 forms open and edit one of the forms and then close one
or both of the forms I get a message stating I need to save or drop
change. If I don't drop changes, I usually lose whatever I've just
added. If I dont drop changes, and save I on several occasions I have
made the database inoperable.

Any suggestions on what I am doing wrong?

Any help would be greatly appreciated.

Best wishes,

George Hadley
(e-mail address removed)

 

[roadie.girl]

you've done nothing wrong - what happens is that whenever you open up a
record, the database locks the record from another user from editing
it. (Kinda like only one person can go to the bathroom at the same time
.... when you go in, you lock the door ... the next person just has to
wait until the person inside there gets done).

So when you have 2 forms opened up the first form locks the record ...
then the 2nd one when accessing the SAME record the 1st one is
accessing.

So what you're doing is just trying to change the same record twice at
the same time.

Make sense?