Home

How to Password protect queries in Microsoft Access

Oct 18, 2008 07:23 PM

Code snippet in Visual Basic for a password prompt.

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.

You already know how to use your phone. With Gadget Hacks' newsletter, we'll show you how to master it. Each week, we explore features, hidden tools, and advanced settings that give you more control over iOS and Android than most users even know exists.