Only one source of data input at a time.

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

Guest

I have created a very simple database to track and keep a record of tape
recordings made in my workplace. Each tape is given a unique number and the
details of the content of the tape are held. The database will be used on a
Network. My problem is that I must lock it down so that only one person can
input information at a time. I can see no field in access that allows me to
do this. Does anyone have any ideas?
 
On Sat, 17 Jun 2006 14:57:02 -0700, Vincent halas <Vincent
I have created a very simple database to track and keep a record of tape
recordings made in my workplace. Each tape is given a unique number and the
details of the content of the tape are held. The database will be used on a
Network. My problem is that I must lock it down so that only one person can
input information at a time. I can see no field in access that allows me to
do this. Does anyone have any ideas?
Click to expand...

You can open the database using the /Excl switch to open it
exclusively, or set Tools... Options... General to default to
exclusive use (of course if the updating person has it open nobody
else will even be able to read it until they close).

Why this restriction? Access handles database contention pretty
well...

John W. Vinson[MVP]
 
All you really need is to lock the Edited record in Tools, Options, Advanced,
This should just lock the one record to the person who is changing it. Once
that person "leaves" that record, the next person to open it will see the new
changes and I believe that is what you want to accomplish.
 
Back
Top