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. talxp [url=http://www.foxbeatsbydre.co.uk]beats by dre[/url] juddg http://www.foxbeatsbydre.co.uk edypj [url=http://www.add-beatsbydre.co.uk]beats by dre[/url] xufkc http://www.add-beatsbydre.co.uk dtemb [url=http://www.add-drdrebeats.co.uk]beats by dre[/url] fqlvq http://www.add-drdrebeats.co.uk kzyfm [url=http://www.onlinecheapbeatsbydre.com]dre beats[/url] aibyd http://www.onlinecheapbeatsbydre.com blgsi [url=http://www.justdrdrebeatssale.com]cheap beats by dre[/url] agjzl http://www.justdrdrebeatssale.com bxgwq [url=http://www.vip-beatsbydresale.com]beats by dre[/url] euhpu http://www.vip-beatsbydresale.com rxhs

  4. I am extremely impressed together with your writing skills as neatly as with the structure to your blog. Is this a paid topic or did you modify it yourself? Either way stay up the nice high quality writing, it’s uncommon to see a great weblog like this one nowadays..

  5. If you desire to increase your familiarity simply keep visiting this site and be updated with the most recent news posted here.

  6. jrjgi [url=http://www.im-mulberrybags.co.uk]mulberry bags[/url] hqqhaa http://www.im-mulberrybags.co.uk fhluc [url=http://www.im-mulberryoutlet.co.uk]mulberry outlet[/url] dqjncf http://www.im-mulberryoutlet.co.uk sgrua [url=http://www.pay-mulberrybags.co.uk]mulberry bags[/url] hkjbhh http://www.pay-mulberrybags.co.uk xcok [url=http://www.online-mulberry.co.uk]mulberry outlet[/url] lviyxf http://www.online-mulberry.co.uk mendd [url=http://www.goodcelinehandbags.com]mulberry outlet[/url] tbjava http://www.goodcelinehandbags.com fuldb [url=http://www.onlinecelinebags.com]mulberry bags[/url] urdzdh http://www.onlinecelinebags.com dmxh

  7. Attractive section of content. I just stumbled upon your blog and in accession capital to assert that I get actually enjoyed account your blog posts. Any way I will be subscribing to your augment and even I achievement you access consistently quickly.

  8. Hi there! This blog post could not be written much better!
    Reading through this post reminds me of my previous roommate!
    He continually kept preaching about this. I most certainly will send this information to him.
    Pretty sure he’s going to have a great read. Thanks for sharing!

  9. I’ve read some excellent stuff here. Certainly value bookmarking for revisiting. I surprise how so much effort you set to create this sort of excellent informative web site.

  10. I like the invaluable information you give in your reports.I will bookmark your site and look at again here often.I’m somewhat totally sure I’ll find out a lot of recent things best suited below! Very good luck for the future!

  11. So that they run will not be as intensive as other creditors may run. Regardless of whether a homeowner maintains regular payments on their first mortgage, the second lien holder home equity loans or home equity quotes from multiple lenders. A loans modification offers numerous benefits and depreciation expense. The last thing you need when faced with mounting debts and bills is another personal loans that they run will not review incomplete requests.

  12. {The new morphine tablet is a tablets containing a hundred to 2 hundred small pellets. Regrettably, this type of solution can result in even worse problems compared to back ache: Drug dependancy, addiction and a stint within medical drug cleansing – not really a solution to back discomfort in anyone’s publications.|The specific self-test kits are generally easy to use along with simple-to-understand visible outcomes which are shown within 5 moments following an one-step qualitative evaluation. For all those watching television as well as a drug advertisement happens, speak about the medial side associated with the medication and inform your kid much more about all of them.|Methadone is highly addictive and exceedingly difficult to stop consuming. Educate them about alternatives to drugs in these various circumstances, and how to say no . Prescription medications can be dangerous for your wellness, and lots of are seriously addictive and can even kill you.|The brand new morphine gadget is a capsule containing 100 to 190 tiny pellets. It should be kept it out from the reach of youngsters, as an unintended overdose with a child may result in demise. Most of these medicines are extremely harmful and addicting.|Billed for the killing are their 13-year-old half-brother, a 13-year-old friend, along with a 20-year-old neighborhood university student. As well as Americans aren’t just perishing from OxyContin addiction and abuse. It comes with an improved risk of craving and abuse while applying oxycontin.|Methadone is also difficult to be able to prescribe: It offers pain alleviation for some hours, but remains in the bloodstream long after that. | This is actually the issue I see numerous people who simplistically look at being around the medication since the sole method to recover from opiate habit.|Within Missouri, a federal grant helped study the program, but the legislature failed to pass it due to financing problems and privacy concerns.

  13. Never had a problem reading this sort of thing. You take away so much! Ta brother, one more site I have to remember to visit!

  14. Hi there, just became aware of your blog through Google, and found that it’s really informative. I am going to watch out for brussels. I will appreciate if you continue this in future. Many people will be benefited from your writing. Cheers!

  15. mbgfm [url=http://www.salelouisvuitton-no1.com]authentic louis vuitton[/url] nuyugx http://www.salelouisvuitton-no1.com bvyrh [url=http://www.get-louisvuittonoutlet.com]louis vuitton bags[/url] ummdoy http://www.get-louisvuittonoutlet.com qwlvl [url=http://www.pick-louisvuittonoutlet.com]louis vuitton handbags[/url] plqkaq http://www.pick-louisvuittonoutlet.com fqoz [url=http://www.foxlouisvuitton.com]louis vuitton outlet[/url] uyodtd http://www.foxlouisvuitton.com vyziu [url=http://www.lo-louisvuittonoutlet.com]louis vuitton outlet[/url] wseogj http://www.lo-louisvuittonoutlet.com tgxjl [url=http://www.locheaplouisvuitton.com]louis vuitton outlet[/url] wmlefn http://www.locheaplouisvuitton.com eebx

  16. From the perspective of the reasons they designed and built their scooter. You need an electric bike, you will not have to use gasoline again and you move on to a neighborhood convenience store.

  18. edspv [url=http://www.foxbeatsbydre.co.uk]dre beats[/url] viqoo http://www.foxbeatsbydre.co.uk vrrmd [url=http://www.add-beatsbydre.co.uk]beats by dr dre[/url] lthwr http://www.add-beatsbydre.co.uk lznjk [url=http://www.add-drdrebeats.co.uk]dre beats[/url] myqkm http://www.add-drdrebeats.co.uk azzim [url=http://www.onlinecheapbeatsbydre.com]cheap beats by dre[/url] slfdn http://www.onlinecheapbeatsbydre.com cguxj [url=http://www.justdrdrebeatssale.com]beats by dre sale[/url] yxxzp http://www.justdrdrebeatssale.com deksn [url=http://www.vip-beatsbydresale.com]dr dre beats[/url] ophdp http://www.vip-beatsbydresale.com mxqg

  19. hkcyl [url=http://www.foxbeatsbydre.co.uk]dr dre beats[/url] jncef http://www.foxbeatsbydre.co.uk jkpdh [url=http://www.add-beatsbydre.co.uk]dr dre beats[/url] rqtwz http://www.add-beatsbydre.co.uk inzfv [url=http://www.add-drdrebeats.co.uk]dr dre beats[/url] wdmbi http://www.add-drdrebeats.co.uk fagdt [url=http://www.onlinecheapbeatsbydre.com]cheap beats by dre[/url] udmpo http://www.onlinecheapbeatsbydre.com pryaa [url=http://www.justdrdrebeatssale.com]beats by dre[/url] wfdlg http://www.justdrdrebeatssale.com ffrlu [url=http://www.vip-beatsbydresale.com]cheap beats by dre[/url] ehora http://www.vip-beatsbydresale.com qnfa

  21. dfxdhh http://www.cheaper-montblancpens.com clejh [url=http://www.montblancpensincheap.com]Mont Blanc[/url] elueue http://www.montblancpensincheap.com mnfka [url=http://www.montblanconlines.com]Mont Blanc Pens[/url] vvaglh http://www.montblanconlines.com wanv [url=http://www.cheapmontblancpens.co.uk]Mont Blanc[/url] zliuji http://www.cheapmontblancpens.co.uk aayfj [url=http://www.salemontblancpens.co.uk]Mont Blanc Pen[/url] jujwqj http://www.salemontblancpens.co.uk tgbfa [url=http://www.montblanconlines.co.uk]Mont Blanc Pens rvahiw http://www.montblanconlines.co.uk jvig

  22. ywlamq http://www.cheaper-montblancpens.com ngfjn [url=http://www.montblancpensincheap.com]Mont Blanc Pen[/url] cmeixh http://www.montblancpensincheap.com qrjje [url=http://www.montblanconlines.com]Mont Blanc Pens[/url] avacvn http://www.montblanconlines.com yudn [url=http://www.cheapmontblancpens.co.uk]Mont Blanc[/url] wcjthy http://www.cheapmontblancpens.co.uk slcbj [url=http://www.salemontblancpens.co.uk]Mont Blanc[/url] sczoux http://www.salemontblancpens.co.uk bfrjp [url=http://www.montblanconlines.co.uk]Mont Blanc Pen eswqvc http://www.montblanconlines.co.uk afxj

  23. onmid [url=http://www.getcanadagooseoutlet.com]canada goose[/url] bhobqp http://www.getcanadagooseoutlet.com bxizg [url=http://www.pick-canadagoose.com]canada goose sale[/url] sbzduh http://www.pick-canadagoose.com zjtrt [url=http://www.pickupcanadagoose.com]canada goose[/url] ekhbqm http://www.pickupcanadagoose.com unvo [url=http://www.pay-canadagooseoutlet.com]canada goose outlet[/url] stkvea http://www.pay-canadagooseoutlet.com iifye [url=http://www.yescanadagooseoutlet.com]canada goose jacket[/url] wecgax http://www.yescanadagooseoutlet.com cggxk [url=http://www.online-canadagooseoutlet.com]canada goose jacket[/url] sxgder http://www.online-canadagooseoutlet.com nznp

  24. gqvjq [url=http://www.add-celinehandbags.co.uk]celine bags[/url] fddutt http://www.add-celinehandbags.co.uk fyaxp [url=http://www.add-celinebags.co.uk]celine bag[/url] adpcad http://www.add-celinebags.co.uk rqfsn [url=http://www.getcelinebags.co.uk]celine handbags[/url] gzpmit http://www.getcelinebags.co.uk vtxc [url=http://www.pay-celinebags.co.uk]celine bags[/url] fhyhdk http://www.pay-celinebags.co.uk dzjht [url=http://www.pay-celinehandbags.co.uk]celine handbags[/url] jxufik http://www.pay-celinehandbags.co.uk hasmt [url=http://www.online-celinebags.co.uk]celine bag[/url] zkksfp http://www.online-celinebags.co.uk nkic

  25. Between me and my husband we’ve owned more MP3 players over the years than I can count, including Sansas, iRivers, iPods (classic & touch), the Ibiza Rhapsody, etc. But, the last few years I’ve settled down to one line of players. Why? Because I was happy to discover how well-designed and fun to use the underappreciated (and widely mocked) Zunes are.

  26. ewjfa [url=http://www.im-mulberrybags.co.uk]mulberry handbags[/url] jmybqt http://www.im-mulberrybags.co.uk fzkog [url=http://www.im-mulberryoutlet.co.uk]mulberry handbags[/url] wytpct http://www.im-mulberryoutlet.co.uk juijr [url=http://www.pay-mulberrybags.co.uk]mulberry handbags[/url] orgvln http://www.pay-mulberrybags.co.uk nihj [url=http://www.online-mulberry.co.uk]mulberry outlet[/url] kiqmlx http://www.online-mulberry.co.uk lzovs [url=http://www.goodcelinehandbags.com]mulberry outlet[/url] hvmbxi http://www.goodcelinehandbags.com uryyt [url=http://www.onlinecelinebags.com]mulberry outlet[/url] hbqnip http://www.onlinecelinebags.com keew

  27. rjlfm [url=http://www.im-mulberrybags.co.uk]mulberry bags[/url] okhigx http://www.im-mulberrybags.co.uk yblgq [url=http://www.im-mulberryoutlet.co.uk]mulberry sale[/url] juhwbt http://www.im-mulberryoutlet.co.uk qmpyp [url=http://www.pay-mulberrybags.co.uk]mulberry outlet[/url] muajlw http://www.pay-mulberrybags.co.uk midp [url=http://www.online-mulberry.co.uk]mulberry outlet[/url] knslnk http://www.online-mulberry.co.uk zycyg [url=http://www.goodcelinehandbags.com]mulberry bags[/url] fyufyd http://www.goodcelinehandbags.com dndvg [url=http://www.onlinecelinebags.com]mulberry bags[/url] xtbvjs http://www.onlinecelinebags.com ufzm

  28. Terrific paintings! That is the kind of information that should be shared across the web. Disgrace on Google for not positioning this submit upper! Come on over and talk over with my website . Thank you =)

  29. I like what you guys are up too. Such smart work and reporting! Carry on the excellent works guys I’ve incorporated you guys to my blogroll. I think it’ll improve the value of my site :).

  30. I believe other website proprietors should take this internet site as an example , very clean and great user pleasant layout.

  31. Thanks for every other informative blog. Where else may I get that type of info written in such a perfect approach? I have a challenge that I’m simply now running on, and I’ve been at the look out for such information.

  32. Spot on with this write-up, I actually assume this web site needs way more consideration. I’ll most likely be once more to read much more, thanks for that info.

  34. Greetings from Los angeles! I’m bored at work so I decided to check out your website on my iphone during lunch break. I really like the info you provide here and can’t wait to take a look when I get home. I’m amazed at how quick your blog loaded on my phone .. I’m not even using WIFI, just 3G .. Anyhow, fantastic blog!

  35. zcyfe [url=http://www.getcanadagooseoutlet.com]canada goose jacket[/url] kxwqrs http://www.getcanadagooseoutlet.com hgozg [url=http://www.pick-canadagoose.com]canada goose sale[/url] iupgoe http://www.pick-canadagoose.com tnbfz [url=http://www.pickupcanadagoose.com]canada goose[/url] csqvcp http://www.pickupcanadagoose.com dolc [url=http://www.pay-canadagooseoutlet.com]canada goose[/url] pjybgv http://www.pay-canadagooseoutlet.com tupam [url=http://www.yescanadagooseoutlet.com]canada goose[/url] juklfc http://www.yescanadagooseoutlet.com rwrmi [url=http://www.online-canadagooseoutlet.com]canada goose[/url] ycwvli http://www.online-canadagooseoutlet.com pcuw

  37. It’s appropriate time to make a few plans for the long run and it is time to be happy. I have learn this submit and if I could I desire to counsel you few attention-grabbing things or advice. Perhaps you can write subsequent articles referring to this article. I wish to learn even more things approximately it!

  39. Wow that was odd. I just wrote an incredibly long comment but after I clicked submit my comment didn’t show up. Grrrr… well I’m not writing all that over again. Anyway, just wanted to say excellent blog!

  40. Business Insider, by way of Reddit, posted the story earlier today, and I think they can offer you better conditions. The SBA will cover the risk that their days of home ownership. Borrowers will have an idea of what price range you can expect to pay it back on time. Learn how to effectively and economically tap their commercial property’s equity.

  41. Thanks for making me to attain new concepts about pcs. I also have the belief that one of the best ways to maintain your laptop in excellent condition is a hard plastic material case, as well as shell, that suits over the top of one’s computer. These kinds of protective gear are usually model targeted since they are manufactured to fit perfectly within the natural casing. You can buy these directly from the owner, or from third party places if they are intended for your laptop, however not all laptop could have a covering on the market. Yet again, thanks for your suggestions.

  42. It’s really a nice and useful piece of information. I am glad that you shared this helpful information with us. Please stay us informed like this. Thanks for sharing.

  44. Hey! I know this is somewhat off topic but I was wondering which blog platform are you using for this website? I’m getting sick and tired of WordPress because I’ve had problems with hackers and I’m looking at alternatives for another platform. I would be awesome if you could point me in the direction of a good platform.

  45. Thanks for a marvelous posting! I actually enjoyed reading it, you can be a great author.I will be sure to bookmark your blog and will come back in the foreseeable future. I want to encourage you to ultimately continue your great writing, have a nice day!

  47. I blog quite often and I seriously appreciate your content. This great article has truly peaked my interest. I am going to take a note of your blog and keep checking for new details about once per week. I subscribed to your Feed too.

  49. I am just writing to make you be aware of of the remarkable discovery my wife’s princess enjoyed viewing your web page. She learned several details, which included what it’s like to have an excellent coaching heart to get men and women very easily fully understand specific impossible topics. You actually surpassed our own desires. I appreciate you for giving such beneficial, dependable, edifying and in addition fun tips about your topic to Tanya.

Comments are closed.