Tables inaccessible to users (Access 2000)

Topic

New Reply

Sometimes my users neglect the forms i have provided for editing the tables, and make some changes in the tables themselves.Is there any way to prevent the users to have any access to the tables? I use Front En d with linked tables and i am curious to know is there any way to prevent users from liikong up the tables themselves ?

Reply | Quote

Replies

The only sure way to do this is to set up User Level Security. You can then set the “permissions” for the Groups to not allow access to the specific obects you do not want to to have access to.

HTH
RDH

Reply | Quote

You can also set the tables property (and your other objects too) Attributes to Hidden.

Right click on the table, select

Reply | Quote

There are two ways to set a table to hidden. The way you suggested works properly in all the versions and won’t cause tables to be deleted.

Reply | Quote