Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do protect a form where no one but me can access it through menu?

Status
Not open for further replies.

davesaint

IS-IT--Management
Feb 22, 2002
86
US
I created a form named Systems Adminstration. Right now users can access this form through the main switchboard. How can I setup this form up were it is password protected. If this is not possible what will work as a workaround?
 
When I design a database, I make it impossible for users to reach the database window. (Prevents a lot of mischief)

I then keep a "backdoor" open that I can use to get into the database in order to open tables, modify database design, etc.

If this sounds like what you want then read faq181-1021. Maq [americanflag]
<insert witty signature here>
 
If users access your form through a switchboard using a button, you could make that button invisible by setting the visible property of the button to &quot;No&quot;. Then (assuming you have MSAccess security in place) based on your username, you could make that button available only to you by setting it's visible property to &quot;Yes&quot; during the OnOpen event procedure of the switchboard.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top