Table password

[Gloria]

I have a database and I would like to hide my tables, reports, and forms when
somebody opens the database. How can I set up so they can stay hidden when
somebody opens the database? Another question is if I can set a password so
nobody can access to the tables, reports and forms in my database. If they
are hidden from the users, I want to set up a password so nobody can unhide
them unless the password is known. Thanks

 

[Dennis]

Several ways to accomplish what you want....

- Workgroup security will provide password protection, as well as "rights"
to modify/view/run/etc the various forms, queries and reports in your database

- Setting the Statup Options to UNCHECK "Show database window" will hide
everything (easy for a knowledgeable user to get past though)

- Each object in your database (form, query, report, etc) has a set of
properties. You can right click on each object, and click on HIDDEN. This too
is easy enough to get past by a knowledgeable user.

Only Workgroup Security is really secure, and that has been discontinues as
of Access 2007.

 

[Gloria]

Thanks for your help

Several ways to accomplish what you want....

- Workgroup security will provide password protection, as well as "rights"
to modify/view/run/etc the various forms, queries and reports in your database

- Setting the Statup Options to UNCHECK "Show database window" will hide
everything (easy for a knowledgeable user to get past though)

- Each object in your database (form, query, report, etc) has a set of
properties. You can right click on each object, and click on HIDDEN. This too
is easy enough to get past by a knowledgeable user.

Only Workgroup Security is really secure, and that has been discontinues as
of Access 2007.