Check in/Check out Capability

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Our staffing firm tracks applicants using an Access database. Each person in
our office is constantly adding updates to records. Is there a check
in/check out capability in Access so we aren't in a record at the same time?
 
You can set up locks so that only one person can access a record at a time.
I would not recommend it though. Typically Access handles sharing very
well. Have you actually encountered any problems? Have you gotten any
messages indicating that another user has made updates to the record?

I've found that it is very rare that two people would be making a change to
the same record at the same time.

If you do still want to do this, check out the Tools/Options/Advanced. Take
a look at the "Open databases using record-level locking" and the "Default
record locking" settings.
 
We have actually encountered a problem sharing. One user's additions to the
record were dropped and had to be reentered. Normally this wouldn't be a
problem except that we handle such a large volume of data. Why wouldn't you
recommend using the locks?
 
Back
Top