How To: Password protect databases with Microsoft Access

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:

If Username = "user1" And Password = "user1" Then
MsgBox "Access Granted", vbInformation, "CD Shop"
MsgBox "Welcome", vbInformation, "CD Shop"
DoCmd.OpenForm "F_Switchboard"
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.

Get the Gadget Hacks Daily

Our latest smartphone hacks — straight to your inbox.

Be the First to Comment

Share Your Thoughts

  • Hot
  • Latest