#REMOVE MS ACCESS PASSWORD HOW TO#
#REMOVE MS ACCESS PASSWORD PASSWORD#

Thanks for reading this tutorial on password protecting a form or report in a microsoft access database.

#REMOVE MS ACCESS PASSWORD HOW TO#

Just remember that this is not really completely secureВ becuase anyone who knows how can just look at the form in design view and then check the вЂonloadвЂ™ event code to discover the hard-coded password, but the average user will never know how to do this anyway, so this is a reasonably decent solution. So there you have it, a pretty easy and basic password protection system to password protect a form or report in Microsoft access.В This will work with just about any version of Access, so give it a try. Now,В you can change вЂњEnter PasswordвЂќ to whatever message you want to appear when the password box comes up, and likewise, you can changeВ the вЂњWrong Password?вЂќ part to whatever message that you want to display when the user enters the wrong password or does not enterВ any password at all. And then change the вЂњname of the form that you want to password protectвЂќ to the name of your form. To use this you will need to change the line that says вЂњwhatever password you choose hereвЂќ to whateverВ you want the password to be. I think that this canВ be changed but that is beyond the scope of this tutorial. Another thing I should mention is thatВ the text for the password is not dotted out or starred out like is usually is with password protection forms. If you enter the correct password then it will open, otherwise it will not. Now try to open the form and you will get a password box before theВ form will open. Save the code and exit and also save the changes to the form.

Open FormDoCmd.OpenForm вЂњname of the form that you want to password protectвЂќ If PassWord = вЂњwhatever password you choose hereвЂќ ThenвЂ™ All we need to do is to add the code to this section. This will bring up a Visual Basic window (see photo 2) which will have a method for the вЂonloadвЂ™ eventВ preloaded. So click on the tiny icon with the three little dots on it and on the window that pops up,В select вЂcode builderвЂ™. Here we want to add some code to the on load event so that it willВ first prompt the user for a password. Under the events tab you will see a field called вЂon loadвЂ™ (see photo 1), this is the field that controlsВ what the form or report does when it is first loaded or opened. Open the form or report that you want to password protect in design view and find вЂformвЂ™ in the properties field (see photo 1). But if you just need a basic password protection to protect just one or a few forms from average usersВ then this method will work and it is also quick and very easy. Having saidВ that, this method is still pretty useful for just average applications, like I said it is not really the most secure method, so ifВ your application contains really sensitive data (like social security numbers or bank account numbers) then I would advise usingВ another more secure method. But in order for someone toВ find the password (which is hard-coded into the application) they would have to have at least basic knowledge of access from theВ design and programming point of view, so if they are just users then chances are that they will never discover the password (byВ looking at the code behind the program) unless someone tells it to them or they discover it written down somewhere. Just as an aside, this is not the most secure method and in fact is not really secure at all. With justВ a few lines of code in the right place you can prevent unwanted users from opening and viewing or editing data in your form orВ report. And password protecting a form or report is no exception.

Microsoft makes doing a lot of things with databases very easy. How to Password Protect a Form or Report in Access

Remove ms access password