Is there a way to see if a record has been changed by another user before attempting to save it?

  • Thread starter Thread starter Blue
  • Start date Start date
B

Blue

Using Access 2000. I'm looking for a way to tell if a record has been
changed by another user before attempting to save over it using VB

Something like:

Form is opened on machine #1

Different form accessing the same recordset opened on machine #2

Data changed and saved on machine #2

Data changed on machine #1

<-- Here is where I want to see that the record has been changed elsewhere.
If it has, discard the changes on #1, if not, save 'em.


TIA
 
It is possible to make what are you describing, but require a lot of coding.
you have to write who changed record last time, then on beforeupdate event
check this and decide if you want to save record.
Probably better way is to use locking.
 
Back
Top