Locked records

[Guest]

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?

 

[Joseph Meehan]

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?

I am not sure if you are aware that in Access, pages, not records are
locked. So if someone is editing a record, that record is locked and so
many several other records locked.

Have you considered batch processing of additions and edits? I found
batch processing eliminated essentially all our problems of locked records.

I also found that two copies of a database, one for those editing and
one for the large number of those who only view data, and can work with
yesterday's data can help out with speed and other concerns. I had an
automatic copy of the working database over night to a different location
for viewing only. It also assured that when one of the general population
of viewers accidentally deleted the database, it would correct itself in
less than 24 hours.

 

[Guest]

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