i have an access database that i need to create a login mechanism for it using a vba form with a table that contains 3 fields user pass and level. I want a code that when the user name and password are entered it matches it with the table row and if pass is ok ill make some other form open.
please help me with a valid code and if don’t know don’t answer please.
thanks.
Related posts:








1 response so far ↓
1 garbo7441 // Sep 5, 2008
Access allows the setting of a password without having to write a macro in VBA. Can you not use the built in password protection?
To do this in Access 2003:
Open Access
File > Open
Find the Database you want to password protect.
Click on it ONCE
Select: Open Exclusive from the ‘Open’ dropdown menu, bottom right.
When it opens, go to Tools > Security
Select: Set Database Password….
Leave a Comment