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:
If Password = "Manager1" Then
MsgBox "Access Granted", vbInformation, "CD Shop"
MsgBox "Delete Query Active", vbInformation, "CD Shop"
DoCmd.RunMacro "M_ArchiveStock"
MsgBox "Deletion Confirmed"
MsgBox "Please re-enter your Password."
End If

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

Want to master Microsoft Excel and take your work-from-home job prospects to the next level? Jump-start your career with our Premium A-to-Z Microsoft Excel Training Bundle from the new Gadget Hacks Shop and get lifetime access to more than 40 hours of Basic to Advanced instruction on functions, formula, tools, and more.

Buy Now (97% off) >

Other worthwhile deals to check out:

Join the Next Reality AR Community

Get the latest in AR — delivered straight to your inbox.

Be the First to Comment

Share Your Thoughts

  • Hot
  • Latest