tables

P

Pammy

Is there a way to set a table where if I have it opened no one else can enter
on it. It will tell them it is read only? There are other tables, so they
could go and enter infor on one of those until this one would be free.
 
A

Arvin Meyer [MVP]

You cannot do this for one table, but you can lock the entire list of tables
as each one is entered by setting the option to Table in:

Tools >>> Options >>> Advanced >>> Default Record Locking

set to All Records. In order to do that you'll need to start editing before
the lock is applied. The first one editing will lock the table.

If you use a form, which is what you should be doing since it is not ever a
good idea to allow users direct access to tables, you can create a lock
table on the server and have each person check when they open the form. The
only problem with that is if someone exits the database incorrectly, (like
Ctrl+Alt+Del) or shutting down the computer, the table will be left with the
flag still set, and no one will be able to get in until an admin rests the
flag manually.
 
C

Coffee Gal

Do you not want anyone in the entire table you are using or only in the
actual record you are editing?
 
Top