Locked records

C

Chris Mortimore

I have a database setup that allows multiple users to access it at the same
time. Basically, there are two parts: "frontend.mdb" and "data.mdb". The
forms in frontend.mdb read the table in data.mdb (using table linking). Now,
I have it so that when a user is editing a record, a "circle with a line
through it" sign appears on the record selector bar, but this is not too
obvious. Is there a way of having a label that will appear on the form when
a locked record is selected?
 
C

Chris Mortimore

i'm not allowed to say what the database will be used for, but batch
processing is not an option. when this database gets updated, the updates
need to be available immediately, thus record locking was chosen in
preference to batch processing.

access really isnt the best environment for realtime multiuser stuff, but
its all i have been given, so i making do with what i have
 
Top