Stop users using tables in new Queries

[wallis1905]

Hello all,
I am setting up an access 2003 database in a Client/Server configuration. All dat entry is done through queries, forms are not used. I am wondering if it's possible to prevent users in the client database (Or a copy of it) from creating new queries that hang of the linked tables. I want them to hang new queries only from existing queries. This way I can be sure that what they see is always appropriatley filtered. Any ideas?

 

[Dennisk]

why not hide your tables.

 

[wallis1905]

Indeed why not. Thanks for that.

 

[The_Doc_Man]

wallis, another thread has been circulated on that topic. If you do not hide the database window, a slightly savvy user can find the menu-bar option that will unhide hidden tables, queries, etc.

The ONLY way to control this is through forms that do not let users see the database window. Any other advice than this is WRONG. You have no control and no security if your users can see the objects in the database window. None. Zip. Nada. Zilch. This action is merely closing the door on a structure that has no walls.