Prevent users from viewing tables

J

Jeannine

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...
 
S

Scott McDaniel

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Access Lock File .LACCDB / Now shows as a notepad file 0
Creating a Chart on form from selected data in query. 0
Microsoft 365 Activations, Users or Devices? 0
Please help me choose a product for the task 2
Need Help with Macro Security 1
Set up User Restrictions 1
How to remove external organization from Office. 0

Top