Hi everyone. I would like to stop people from changing my tables and queries that I have created. I have seen other databases where you cannot access the tables, queries, forms and other objects. Does anyone know how to do this?

Thanks,

RU1

Hi Ru1,

A quick, and not very secure way, is to hide any objects you like in the database window. Right click the object you want to hide, and check the Hidden attribute check box. To then show hidden objects in the db window, use the Tools -> Options -> Hidden objects checkbox.

The more secure way would be to establish user-level security for your db using the the User-level Security Wizard (Tools -> Security) and grant read-only permissions to whomever you don't want messing with your db design.

HTH,

Bob