how would i password protect but let others access a form in my databa

[chaos18]

Greetings,
Currently i am working on a database for a client and the actual database is hidden, and when the database is opened a form is opened that has all the options and uses the employees need. However a few insist on unhiding the database and looking around and end up causeing a wreck...how would i be able to put an administrator password on the hidden part of the database so the form and its options are still operational but to acces the hidden part a password is requested

 

[tlbroadbent]

Are you using Microsoft Access? If you are, then post your question in forum702, the Access Forms forum.

This is a SQL Server forum and SQL really doesn't do forms. If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm