What is the best way to password protect a single form in a database without password protecting the entire database. I have set up a database to enter to a given form with select fields to go to, what I want to be, an unsecured form, or to go to, what I want to be, a secured (password protected) form.
Results 1 to 2 of 2
-
New Lounger
- Join Date
- Feb 2006
- Posts
- 10
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2006-02-02 15:27Password protecting a single form (Access 2003)
-
Subscribe to get a FREE chapter from Windows 7 The Missing Manual
This month, every Windows Secrets subscriber can download a one-chapter excerpt of Windows 7: The Missing Manual.Windows 7: The Missing Manual provides valuable information to help you overcome these difficulties in learning a new operating system. Subscribe today to download your free excerpt.
-
Plutonium Lounger
- Join Date
- Mar 2002
- Posts
- 84,353
- Thanks
- 0
- Thanked 10 Times in 10 Posts
2006-02-02 15:46Re: Password protecting a single form (Access 2003)
It depends on how secure you want it to be. If it's just meant to prevent users from accidentally opening the wrong form, you could display an InputBox to let the user enter a password, and only open the form if the password provided is correct. But it would be very simple for people to circumvent that.
The only really good way to secure (parts of) a database is to apply user-level security. Lounge moderator <!profile=WendellB>WendellB<!/profile> has a tutorial with useful links on his website: The Secrets of Security.
