How do you hide database objects

S

SharonD

I would like to hide database objects from users. How can I do this in
Access 2007? I would also like to not allow users access to the Data Base
Tools tab. I assume the best way to do this is to use work group
permissions, but I was warned not to use them in 2003.

Consideration: I copy the db from my client via pcanywhere/ work on it/ and
return to them, will this cause any problems
 
T

Tom van Stiphout

On Mon, 7 Dec 2009 08:33:02 -0800, SharonD

To hide a table, right click it and choose "Hidden".

You can provide your own Ribbon and leave out any options you don't
want users to have. For development you would simply not load this
ribbon, or load it in addition to the standard items.

-Tom.
Microsoft Access MVP
 

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

Progamatically hide objects 2
Show/Hide objects based on Security Groups 11
Hide Database Window and unable to change security settings 1
Multiple workgroups same database 2
User Permissions in Access 2007 DB 3
accesing 'protected' database 1
Permanently hide table 2
Help with Splitting and Security Issues 2

Top