Table password

  • Thread starter Thread starter Gloria
  • Start date Start date
G

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
 
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.
 
Thanks for your help

Dennis said:
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.
Click to expand...
 
Back
Top