multi users

[fishqqq]

We have 10 users sharing data on a back end dbase (which is on a
server) and every once in a while there will be2 users using the same
record at the same time.

is there a way to block the 2nd user for updating the record or
possibly having a warning message that there is another user already in
this record BEFORE the 2nd user inputs all the data only to find it
can't be saved etc?

tks

 

[Marshall Barton]

We have 10 users sharing data on a back end dbase (which is on a
server) and every once in a while there will be2 users using the same
record at the same time.

is there a way to block the 2nd user for updating the record or
possibly having a warning message that there is another user already in
this record BEFORE the 2nd user inputs all the data only to find it
can't be saved etc?

I've never had to block edits that way, but I believe that
this is what Pessimistic Locking is supposed to deal with.
Check Help, you should be able to use the RecordLocks
property on the form to get the desired effect.

Don't forget that if you display the Record Selectors, they
provide a visual indicator that a record is being edited.

 

[fishqqq]

Thanks i'll give that a try