Record locking

[Guest]

In Access 2000, On Tools, Options, Advanced Tab I have set the Default
Record Locking to All Records and checked the Open database using record
level locking.

I control my forms with code. I fill a form opening the table as a
snapshot. Only when the user makes a change and saves the form do I open it
as dynaset for the save and immediately close the recordset and the database
connection.

But two people can still get into the same record in the same table at the
same time and make changes. Only the second save is final even though the
other person might have accessed that record first.

How do I correct this issue. I need to control the loading a form and the
saving a record (addnew or update) or the deletion of a record with locking.

Thanks

Shell

 

[John Smith]

Time-stamp the record when you update it.

Before update check that the time-stamp is unchanged since you read it, if not
someone else has updated the record in the interim and you can abort the
update. You just need to decide what to ask the second updater to do about
their changes, they will probably have to do them again on a new copy of the
record!

HTH
John
##################################
Don't Print - Save trees