How to Password Protect a Form or Report in Microsoft Access

Published by Shane-Zentz

How to Password Protect a Form or Report in Access

by Shane Zentz
Microsoft makes doing a lot of things with databases very easy. And password protecting a form or report is no exception. 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. Just as an aside, this is not the most secure method and in fact is not really secure at all. 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. 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 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. So read on to see how this is done.

Open the form or report that you want to password protect in design view and find ‘form’ in the properties field (see photo 1). Then switch to the events tab. 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. Here we want to add some code to the on load event so that it will first prompt the user for a password. So click on the tiny icon with the three little dots on it and on the window that pops up, select ‘code builder’. This will bring up a Visual Basic window (see photo 2) which will have a method for the ‘onload’ event preloaded. All we need to do is to add the code to this section.

 

Here is the code:
Dim PassWord As String

PassWord = InputBox(“Enter Password”)

If PassWord = “whatever password you choose here” Then’

Open FormDoCmd.OpenForm “name of the form that you want to password protect”
ElseMsgBox (“Wrong Password?”)

DoCmd.Close acForm, Me.NameEnd If

Save the code and exit and also save the changes to the form. Now try to open the form and you will get a password box before the form will open. If you enter the correct password then it will open, otherwise it will not. 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. I think that this can be changed but that is beyond the scope of this tutorial.
This code is pretty basic. 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. And then change the “name of the form that you want to password protect” to the name of your form. 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.
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. 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.
Thanks for reading this tutorial on password protecting a form or report in a microsoft access database.

959 thoughts on “How to Password Protect a Form or Report in Microsoft Access”

  3. Undeniably consider that which you said. Your favourite justification appeared to be on the web the easiest thing to consider of. I say to you, I definitely get irked whilst folks think about concerns that they just do not recognise about. You controlled to hit the nail upon the highest and also defined out the whole thing with no need side-effects , folks can take a signal. Will likely be back to get more. Thanks

  4. There are actually quite a lot of particulars like that to take into consideration. That is a great point to carry up. I provide the ideas above as general inspiration but clearly there are questions like the one you convey up the place a very powerful factor will be working in sincere good faith. I don?t know if finest practices have emerged around issues like that, however I’m positive that your job is clearly identified as a good game. Each girls and boys really feel the impression of only a moment’s pleasure, for the remainder of their lives.

  5. Some states allow default interest rates are slowly increasing and banks will not grant you an account: The hard truth is that banks are not prepared to deal with such things. Such lenders make their profit and that is funny. People still need houses to live in and give you a few of the plot, it is his symbolic role in the right information in many communities.

  6. Thanks a bunch for sharing this with all of us you actually know what you’re talking about! Bookmarked. Please also visit my site =). We could have a link exchange agreement between us!

  8. I have not checked in here for a while as I thought it was getting boring, but the last several posts are good quality so I guess I¡¦ll add you back to my everyday bloglist. You deserve it my friend 🙂

  9. Pretty component of content. I just stumbled upon your website and in accession capital to say that I get actually loved account your weblog posts. Any way I’ll be subscribing in your augment and even I success you access persistently rapidly.

  10. We’re a group of volunteers and starting a new scheme in our community. Your web site provided us with valuable info to work on. You have done a formidable job and our whole community will be thankful to you.

  13. We are a group of volunteers and opening a new scheme in our community. Your website provided us with valuable info to work on. You’ve done a formidable job and our whole community will be grateful to you.

  14. Hello, i think that i saw you visited my weblog thus i came to “go back the favor”.I am attempting to to find things to improve my web site!I guess its adequate to use a few of your ideas!!

  15. hello there and thank you for your information ¡V I have definitely picked up anything new from right here. I did however expertise some technical issues using this website, since I experienced to reload the website lots of times previous to I could get it to load properly. I had been wondering if your web host is OK? Not that I am complaining, but slow loading instances times will very frequently affect your placement in google and can damage your high quality score if advertising and marketing with Adwords. Well I¡¦m adding this RSS to my e-mail and could look out for a lot more of your respective exciting content. Ensure that you update this again soon..

  17. Quality articles or reviews is the secret to be a focus for the visitors to pay a visit the site, that’s what this web page is providing.

  19. Wonderful blog! I found it while searching on Yahoo News. Do you have any tips on how to get listed in Yahoo News? I’ve been trying for a while but I never seem to get there! Thanks

  20. It is appropriate time to make some plans for the future and it’s time to be happy. I’ve read this post and if I could I wish to suggest you some interesting things or tips. Maybe you can write next articles referring to this article. I want to read even more things about it!

  21. Its like you read my mind! You appear to understand a lot about this, like you wrote the book in it or something. I feel that you just can do with some % to pressure the message house a little bit, but other than that, that is magnificent blog. A fantastic read. I’ll certainly be back.

  23. Quality posts is the important to interest the visitors to pay a visit the web site, that’s what this web page is providing.

  25. Excellent post. I used to be checking continuously this blog and I am impressed! Extremely useful information specifically the closing phase 🙂 I take care of such information much. I was looking for this particular information for a long time. Thanks and good luck.

  26. I’ve been exploring for a bit for any high-quality articles or blog posts on this sort of space . Exploring in Yahoo I finally stumbled upon this web site. Reading this information So i’m glad to exhibit that I’ve an incredibly excellent uncanny feeling I discovered just what I needed. I so much no doubt will make certain to do not fail to remember this site and provides it a glance regularly.

  30. If you are going away to watch funny videos on the net then I suggest you to pay a quick visit this web site, it includes actually therefore comic not only videos but also other information.

  39. Make a food list composed of nourishing food products, and above all – stay with it.It can possibly be a restriction on the length of time it is possible to devote in the grocery store immediately. Capsiplex Walmart This will likely make you stay stay centered on getting your shown items as opposed to surfing around and being inclined to purchase fatty foods.

  41. A fascinating discussion is definitely worth comment. I believe that you should write more on this topic, it may not be a taboo subject but usually people don’t talk about these topics. To the next! All the best!!

  43. Hi there, just became alert to your blog through Google, and found that it’s really informative. I am going to watch out for brussels. I¡¦ll be grateful if you continue this in future. A lot of people will be benefited from your writing. Cheers!

  44. Keep up the excellent work , I read few articles on this internet site and I conceive that your web site is rattling interesting and contains lots of excellent info .

  47. Hello! This is my 1st comment here so I just wanted to give a quick shout out and tell you I really enjoy reading your posts. Can you recommend any other blogs/websites/forums that go over the same subjects? Many thanks!

  48. It’s in reality a great and helpful piece of information. I am happy that you simply shared this helpful information with us. Please stay us informed like this. Thanks for sharing.

Comments are closed.