How to Password protect databases with Microsoft Access

The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about creating a login form and password protecting your database.

Here's the code:

Username.SetFocus

If Username = "user1" And Password = "user1" Then

MsgBox "Access Granted", vbInformation, "CD Shop"

MsgBox "Welcome", vbInformation, "CD Shop"

DoCmd.Close

DoCmd.OpenForm "F_Switchboard"

Else

MsgBox "Please re-enter your Username and Password."

End If

For more information, including detailed instructions on how to implement the above code, watch this MS Access how-to.