How To: Password protect queries in Microsoft Access

Password protect queries in 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 how to force a password to be entered in order to run a query.

Here's the code:
Password.SetFocus
If Password = "Manager1" Then
MsgBox "Access Granted", vbInformation, "CD Shop"
MsgBox "Delete Query Active", vbInformation, "CD Shop"
DoCmd.RunMacro "M_ArchiveStock"
MsgBox "Deletion Confirmed"
Else
MsgBox "Please re-enter your Password."
End If

For detailed instructions on implementing the above code, watch this video how-to.

It’s Black Friday week on WonderHowTo! Don’t miss out on all of the big sales in the Gadget Hacks and Null Byte shops. And if you’ve been wanting to take some classes without going into debt, check out our best deals on online courses for a variety of skill sets. Don’t miss out on these huge discounts:

See Gadget Hacks’s top 10 BF sales on online courses (up to 99% off) >

See Null Byte’s top 13 BF sales on online courses (up to 99% off) >

Our Best Phone Hacks

Gadget Hacks' tips — delivered daily.

Be the First to Comment

Share Your Thoughts

  • Hot
  • Latest