Prevent users from viewing tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created a access database and set up the startup to view switchboards only.
How can I set it up so that they cannot push the button to open the database
window? I need to be the only person who can see the tables, queries etc...
 
I created a access database and set up the startup to view switchboards only.
How can I set it up so that they cannot push the button to open the database
window? I need to be the only person who can see the tables, queries etc...
Click to expand...

You can set the Startup options (Tools - Startups) to not show the database window, but users can simply hold down the
Shift key to bypass this. You can also disable the Shiftkey bypass http://www.mvps.org/access/modules/mdl0011.htm) which
will be a bit more secure.

You could also implement User Level Security and use RWOP (Run With Owner Permission) queries, then remove all access to
your tables and get at your data only through those queries. This is the most secure method, but also the most difficult
to implement.

Joan Wild has a good site that will introduce you to ULS: www.jmwild.com

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com
 
Back
Top