Hiding tables/queries from other users

[ApriLee1983]

I have created a database on our company's shared drive. It is to be
implemented throughout the department but I want to be able to hide the
tables/queries from other users.

The form and reports need to be left available so that they can be ran on a
daily basis, but I would like to be able to hide the design view from other
users. Is this at all possible?

 

[Keith Wilby]

I have created a database on our company's shared drive. It is to be
implemented throughout the department but I want to be able to hide the
tables/queries from other users.

The form and reports need to be left available so that they can be ran on
a
daily basis, but I would like to be able to hide the design view from
other
users. Is this at all possible?

Yes it is. The "normal" way to do this would be to allow access to data and
reports via forms only. You'd have to set a start-up form, disable the
other start-up options (and hence hide the db window), disable the bypass
key (if necessary) and provide custom menus.

Food for thought, post back if you need more info.

Keith.
www.keithwilby.com

 

[Golfinray]

You would need to split your database into a frontend and backend and keep
the backend file on the lan and copy the FE to each user's computer. Before
you do that you have to compile your database. You can turn the FE into an
MDE file so that then users cannot see your queries. They may still be able
to see the linked tables but would not be able to modify them. They wouldn't
be able to see any of your code. For a complete list see Joan Wild's site at
www.jmwild.com or google Albert Kallal. He has very good info on splitting
your database.