A2K on 2003 SR2 Record Lock Problem

C

cvegas

I have insured that there is no one else is in the system. I rdp into the
system and pull up a record. I do nothing to the record and click on the
cmdClose button. I get the error that "another user has edited the record
copy to clip board or drop changes.

On open of the form I do some calculations and insert the results into a
total field but I would think the close would take care of the update without
this error?

Any help would be appreciated.
 
S

Stuart McCall

cvegas said:
I have insured that there is no one else is in the system. I rdp into the
system and pull up a record. I do nothing to the record and click on the
cmdClose button. I get the error that "another user has edited the record
copy to clip board or drop changes.

On open of the form I do some calculations and insert the results into a
total field but I would think the close would take care of the update
without
this error?

Any help would be appreciated.
Click to expand...

The 'other user' is VBA (or more exactly DAO). The simple solution to this
is to follow the insertion of the calc results with:

Me.Dirty = False

Which forces a record update, so now when you close the form there's nothing
to update.
 
Top