Make a table exclusive (2003)

Topic

New Reply

One of our departments has a very simple database consisting of several tables – no relationships. No forms. They do all their data entry directly in the individual tables (each table tracks correspondence for specific contract – there is a table for each contract). They swear that in the past, the tables were each individually locked so that multiple users can be in the database, but only one user at a time can enter records in the tables. And, now it doesn’t work that way. How can I set the tables to be exclusive? There may be 50 people in the database at one time, but only one person is allowed in a table at a time. How can I do that?

Reply | Quote

Replies

You can have every user set Default Record Locking to All Records in the Advanced tab of Tools | Options…
However, this is a user-level setting, so it will apply to all databases the user opens.
Access does not have a setting for this at the individual table level, but it does at the query and form level.

Reply | Quote

Ok. Thanks. That confirms what I thought.

Reply | Quote