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”

  1. I read every one of the entries over the page and still deficiency of to our inner experiencing hungry! How you can try with it as attract families?

  2. If you happen to could e-mail me with a few strategies on simply the way you made your weblog look this glorious, I’d be grateful.

  4. Lovely just what I was searching for.Thanks to the author for taking his clock time on this one.

  7. Heya this is someωhat of off topic but I waѕ wanting to knοw if blogѕ uѕe WYSIWYG eԁitors or if you have to manually coԁe ωіth HTML.
    I’m starting a blog soon but have no coding knowledge so I wanted to get guidance from someone with experience. Any help would be enormously appreciated!

    Also visit my blog investment services

  10. Hi there, I discovered your web site by the use of Google whilst searching for a similar
    matter, your web site came up, it seems great.
    I’ve bookmarked it in my google bookmarks.
    Hi there, just turned into aware of your blog through Google, and located that it is truly informative. I am gonna watch out for brussels. I’ll appreciate should you proceed this in future.
    A lot of folks will probably be benefited out of your writing.
    Cheers!

  11. Loved this post and have bookmarked your web page. You might really like
    to get more information concerning my personal working experience of
    acne erasing secrets – you can find out far more within my website.

  13. I blog frequently and I really appreciate your information.
    This great article has really peaked my interest. I’m going to take a note of your website and keep checking for new details about once a week. I subscribed to your RSS feed too.

  14. If you want to learn the trick of easy and fast weight-loss and how you
    can burn fat quickly you will need to think about the eat stop eat diet .

    I have given it a complete test drive and I expose the great items as well as the lousy
    in my website – Click through on the up coming url to go to my fast results weight loss
    assessment webpage. Make sure you read my
    personal review right away and see ways you can get a restricted time period cut
    price trial offer.

    weight loss ads is actually a revolutionary new eating plan from a eminent nutritionist
    Brad Pilon. Follow the link to visit my review blog to discover what helps it
    be so valuable – oh yeah, and you may also get a great discounted price.

    Discover the secret of serious fat loss results using 1000
    calorie diet plan. If you have battled to stay on
    course with your diet program then it’s time you took a quick look at these products

  17. Weight training requires the same.You have to include the appropriate resources just to be profitable. Hypergh 14x UK The tips you’ve go through allow me to share things you achieve success in creating your exercise routine.

  19. Excellent site you have here but I was curious about if you knew of any forums that cover the same topics talked about in this article? I’d really love to be a part of group where I can get responses from other experienced individuals that share the same interest. If you have any suggestions, please let me know. Many thanks!

  20. What’s Going down i’m new to this, I stumbled upon this I have found It positively helpful and it has aided me out loads. I am hoping to give a contribution & assist different customers like its aided me. Great job.

  21. Do you mind if I quote a couple of your articles as long as I provide credit and sources back to your weblog? My blog is in the exact same area of interest as yours and my users would genuinely benefit from some of the information you provide here. Please let me know if this alright with you. Thank you!

  22. Excellent post. I used to be checking continuously this weblog and I am inspired! Very useful information specifically the remaining part 🙂 I take care of such information much. I used to be seeking this certain info for a very lengthy time. Thank you and good luck.

  24. I just like the important details you furnish inside your posts.I’ll bookmark your web log and check once more listed here consistently.I’m extremely definitely sure I’ll study quite a lot of new things ideal listed here! Really good luck with the up coming!

  26. hey there and thank you for your information ¡V I have definitely picked up something new from right here. I did however expertise some technical issues using this web site, since I experienced to reload the site lots of times previous to I could get it to load correctly. I had been wondering if your web hosting is OK? Not that I am complaining, but sluggish loading instances times will sometimes affect your placement in google and could damage your quality score if advertising and marketing with Adwords. Anyway 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..

  28. I was just looking for this info for a while. After six hours of continuous Googleing, finally I got it in your website. I wonder what is the lack of Google strategy that don’t rank this type of informative sites in top of the list. Generally the top websites are full of garbage.

  30. I like the priceless facts you provide in your own content articles.I will bookmark your web log and test all over again the following consistently.I’m very sure I will gain knowledge of an awful lot of new stuff suitable below! Decent luck for the up coming!

  32. I like the helpful information you provide in your articles. I will bookmark your weblog and check again here frequently. I’m quite sure I¡¦ll learn a lot of new stuff right here! Best of luck for the next!

  34. Let’s say for example you find an 100 unit apartment building that is inexperienced in this industry. Also, they do not pay themselves with actual paychecks. You are allowed to invest in others.

  35. Lovely just what I was looking for.Thanks to the author for taking his time on this one.

  38. Hi there dear, are you enjoying with this humorous YouTube video? Hmmm, that’s nice, I am as well watching this YouTube humorous video at the moment.

  39. This sort of give excellent outcomes to attorneys offered that they would like to go looking to obtain financing. When asking for money from bank, credit cards as well. However, it may not want to save money on the net.

  41. If you are paying attention to learn SEO strategies then you should read this paragraph, I am sure you will get much more from this article concerning SEO.

  42. Hi there very cool blog!! Guy .. Beautiful .. Wonderful .. I’ll bookmark your site and take the feeds additionally? I’m happy to seek out numerous helpful info right here within the put up, we’d like work out more techniques in this regard, thanks for sharing. . . . . .

  44. I’m extremely pleased to find this site. I wanted to thank you for ones time due to this fantastic read!! I definitely really liked every little bit of it and i also have you book-marked to look at new things in your website.

  46. C:program filesElectric ArtsEADMbinTS3EP02. Because of outdated and obsolete graphics driver.
    One more would probably be the lucky one.

  48. We are a group of volunteers and starting a new scheme in our community. Your website offered us with useful info to work on. You’ve performed an impressive job and our entire neighborhood will probably be grateful to you.

  50. Wonderful website. Lots of helpful info here. I am sending it to several friends ans additionally sharing in delicious. And certainly, thanks in your sweat!

Comments are closed.