Hide Tables& Qrys from Users - only display Switchboard and forms

  • Thread starter Thread starter Heather
  • Start date Start date
H

Heather

Hello,

I only want the users to the the Switchboard when they open the database.
 
How badly?

If you only want the Switchboard to show, but don't mind the occasional
inquisitive user to get at the tables just by pressing F11 key, go to Tools,
Startu, and uncheck the Display Database Window.

If you don't want them to be able to use the F11 key, uncheck the Use Access
Special Keys box. WARNING: That might make it very difficult for you to ever
see the keys yourself!

You could also right click on each table and query and set them to Hidden.
Then go to Tools, Options, View tab and make sure that Hidden Objects and
System Objects are not checked. Still a bright user could know to check those
two options.

You could also rename every table and query with a USys in front of them. Of
course that would break all queries, forms, and reports. Plus checking the
System Objects box circumvents it.

If you really, really don't want users to see things like tables and
queries, you'll need to implement User Level Security and set permissions.
This is a MAJOR undertaking. Also it won't work with Access 2007 .acc
database files.
 
Jerry, in 2007 the simple task of going to "Tools, Options, View tab and make
sure that Hidden Objects and System Objects are not checked" has become
tortuous. Can you help me find the setting? I renamed my table to have a
usys prefix to hide.... but how do I now set to view when i wish?
 

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

Access Switchboard error message 1
switchboard question 3
switchboard problem 4
Switchboard in Access 2007 1
Switchboard Minimized 4
Access Switchboard & Form Issue 2
Switchboard passwords 2
I've lost my Switchboard ! 3

Back
Top