Disallow viewing of hidden objects

[Guest]

I am using Active Directory security in an Access 2003 database and it works
very well for contolling what the user can do from a form. I disable the use
of the ShiftKey so the user has to work with my form when in my database.
The problem I have found is anyone can link to my tables from another
database using the default system.mdw. One of my reasons for using Active
Directory was to avoid the need of creating a new MDW file. I have hidden
all objects in my database but if the linking user has their Access options
set to show hidden objects my objects show up for linking.

Long intro but now my question. Is there a way to programtically set all my
objects from being visible even if show hidden objects is checked. I could
then programmatically show the objects when I needed to perform database
maintenance.

 

[Guest]

One way is to disable the default menus and toolbars which allows users to
click the hidden objects checkbox. Also use tools, startup to eliminate
their ability to customize the menu/toolbar to prevent them from bringing
them back.
It is curious though, because with this method of hiding all objects and
then taking away anyone's ability to unhide them, I would think that this
totally secures the app. But since Access security goes far beyond this
simple procedure, there must still be a way to unhide them.
Good luck.