Results 1 to 2 of 2
2003-03-18, 19:37 #1
- Join Date
- Jan 2003
- Thanked 0 Times in 0 Posts
Add Security to Button (Access 2000)
I have set up a form for my main menu and want to limit access to a button on the form to certian individuals. Is it possible to assign a password to a button which opens another menu?
2003-03-18, 20:51 #2
- Join Date
- Aug 2001
- Evergreen, CO, USA
- Thanked 60 Times in 60 Posts
Re: Add Security to Button (Access 2000)
Other than writing a VBA routine with an embedded password prompt when the button is clicked, No. And even that procedure isn't terribly secure - unless you do some things to button down your database.
I would suggest you implement Access security. In that fashion, each user gets a prompt when the database is opened, but not everyone has to have a password - only users who have special priviledges would have one. In addition to that kind of protection, you gain the advantage of users not being able to delete or alter table designs, form designs, and so on, and you can automatically track who is entering or editing what data. If you want more info, post back.Wendell