Multiple users updating same records ?

  • Thread starter Thread starter John
  • Start date Start date
J

John

An idea to think about is the record locking for edited
records on the forms property list. This way if a person
is in editing the record, nobody can edit the record until
that person is done. The locking only occurs on the
record, not the table.
Good luck.
John


-----Original Message-----
My system is multi-user and all processing is done with unbound controls.
The problem is that when multiple users are updating the
Click to expand...
same record, the last person to save their changes wipes
out the other changes.
Is there any way to handle this?

Currently when a record is updated the process is:
(1) User requests a record
(2) Record is read and moved into unbound controls
(3) User requests 'update'
(4) Record is written with INSERT from unbound controls

The only thing I can think of is to save the original
Click to expand...
record read and then just before the INSERT to read the
record again and compare every column to see if it has
changed, but that would create incredible overhead. Or I
could just save the original update date stamp and if it
has changed, inform the user. Ideas?
 
I dont think that will work with unbound controls?
I read my record via a recordset and then close the recordset so I'd be surprised if Access had any knowledge I wanted to hold it at that point.
- david
 
Back
Top