disable tables ? (Access 2000)

Topic

New Reply

Is there any code to make the tables in a database somehow disabled or allowing no edits
as it is in the forms?

Reply | Quote

Replies

Not in Access.

You can hide the tables, and disable ways of showing them again using the various options in Tools…Startup (including the Advanced options) .

If you institute Access security you can also remove therights of certain users from making desing changes. If you also remove their right to add data to the table, they won’t be able to do it via a form either so that is probably not what you want.

Reply | Quote

If you implement User Level Security, you can deny users the right to view or modify the tables directly, but instead work through queries by using Read With Owners Permission queries (RWOP).

Reply | Quote