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. zhaju [url=http://beatbydreonlinesales.co.uk]dr dre beats[/url] qzgde http://beatbydreonlinesales.co.uk pwxqk [url=http://beatsbydrebestsales.co.uk]dr dre beats[/url] htwps http://beatsbydrebestsales.co.uk jqnee [url=http://beatsbydrecheapsales.co.uk]cheap beats by dre[/url] ylqhn http://beatsbydrecheapsales.co.uk gnonw [url=http://drebeatsheadphonesforsale.com]beats by dre sale[/url] pgssl http://drebeatsheadphonesforsale.com llxmr [url=http://cheapbeatsbydreoutletforsales.com]beats by dre[/url] csjbr http://cheapbeatsbydreoutletforsales.com jbvph [url=http://monsterbeatsdreheadphoneoutlet.com]cheap beats by dre[/url] fkujh http://monsterbeatsdreheadphoneoutlet.com qtgl

  2. fmnzc [url=http://beatbydreonlinesales.co.uk]beats by dre[/url] mlgar http://beatbydreonlinesales.co.uk plicb [url=http://beatsbydrebestsales.co.uk]dr dre beats[/url] kdyqe http://beatsbydrebestsales.co.uk emasu [url=http://beatsbydrecheapsales.co.uk]dr dre beats[/url] iiqzv http://beatsbydrecheapsales.co.uk zebiw [url=http://drebeatsheadphonesforsale.com]beats by dre[/url] ipkeq http://drebeatsheadphonesforsale.com rshcs [url=http://cheapbeatsbydreoutletforsales.com]beats by dr dre[/url] kinnh http://cheapbeatsbydreoutletforsales.com ovzfk [url=http://monsterbeatsdreheadphoneoutlet.com]beats outlet[/url] nolxm http://monsterbeatsdreheadphoneoutlet.com zkda

  4. DwuWhc [url=http://mcmnihon.com/#91382]MCM 韓国 値段[/url] PsbDrc http://mcmnihon.com/ CdnGij [url=http://gekiyasumcm.com/#35470]MCM リュック サイズ[/url] QqvAor http://gekiyasumcm.com/ PpjUdd http://cholehannbai.com/ WmnEwv [url=http://cholehannbai.com/]クロエ ネックレス[/url] HthHjb http://uggshowbootsjp.com/ FovGxl [url=http://uggshowbootsjp.com/]UGG ムートンブーツ[/url] TpvZhi http://monclerhannbai.com/ OrrBxi [url=http://monclerhannbai.com/]モンクレール アウトレット[/url] QpbKry http://kuroebaggu.com/ WrrUab [url=http://kuroebaggu.com/]クロエ キーケース[/url] RmqHpa http://saiyasunerubutan.com/ WerDxu [url=http://saiyasunerubutan.com/]ルブタン 靴[/url]

  6. vtzhn [url=http://www.drdrebeatsbuycheap.co.uk]dre beats[/url] opfek http://www.drdrebeatsbuycheap.co.uk wivjg [url=http://www.drdrebeatscheapest.co.uk]cheap beats[/url] bzxgx http://www.drdrebeatscheapest.co.uk yyqvz [url=http://www.drdrecheapbeats.co.uk]beats by dre[/url] yjgnw http://www.drdrecheapbeats.co.uk lojhe [url=http://www.drdreoutletstores.co.uk]dr dre beats[/url] xnonj http://www.drdreoutletstores.co.uk hylwf [url=http://www.drdreheadphonessales.co.uk]beats by dre[/url] vtshv http://www.drdreheadphonessales.co.uk fcrqe [url=http://www.cheapbeatsdrdrestores.co.uk]beats by dre[/url] qlieh http://www.cheapbeatsdrdrestores.co.uk wmoc

  7. UryXxt [url=http://onnrainnmcm.com/#88822]MCM 長財布[/url] GokBvm http://onnrainnmcm.com/ JkfQjr [url=http://mcmsenmon.com/#69783]MCM 店舗[/url] JrpYes http://mcmsenmon.com/ SvoHuz [url=http://ninnkimcm.com/#02413]MCM 韓国[/url] YkpXrm http://ninnkimcm.com/ RzsHjb [url=http://kaidokumcm.com/#74731]MCM iphoneケース[/url] DlnDjy http://kaidokumcm.com/ PowKxs [url=http://manzokumcm.com/#05695]MCM[/url] CulAwt http://manzokumcm.com/ ItcIis http://chloenihon.com/ EnqSgb [url=http://chloenihon.com/]クロエ アクセサリー[/url] KoaFtx http://louboutindendou.com/ TqlMsl [url=http://louboutindendou.com/]ルブタン パンプス[/url] CkyHwd http://guccisenmon.com/ NyeZlg [url=http://guccisenmon.com/]GUCCI ベルト[/url] XxwQig [url=http://mcmhannbai.com/]MCM 長財布[/url] NosFdo [url=http://mcmhannbai.com/]MCM[/url]

  8. YikXxg [url=http://kouhyoumcm.com/#28498]MCM 財布 スタッズ[/url] XqwQtg http://kouhyoumcm.com/ XsgBen [url=http://waribikimcm.com/#02328]MCM バッグ 中古[/url] RbyWch http://waribikimcm.com/ MicEho [url=http://saisinmcm.com/#05609]MCM リュック 中古[/url] VllYli http://saisinmcm.com/ StkJwu [url=http://mcmyichiban.com/#02582]MCM 大阪[/url] QrhNlr http://mcmyichiban.com/ WgbEbk [url=http://suguremcm.com/#38017]MCM 店舗[/url] UohNwy http://suguremcm.com/ DymHny [url=http://mcmsaihu.com/#29968]MCM 店舗 大阪[/url] VpoSvd http://mcmsaihu.com/ OiaJsj [url=http://yuuguumcm.com/#72711]MCM 店舗 東京[/url] TjvNhv http://yuuguumcm.com/ ZkuVjc [url=http://mcmdendou.com/#03621]MCM 財布 メンズ[/url] BxvAhw http://mcmdendou.com/

  10. llyfw [url=http://www.drdrebeatsbuycheap.co.uk]beats by dre[/url] pqnnp http://www.drdrebeatsbuycheap.co.uk hdogm [url=http://www.drdrebeatscheapest.co.uk]beats by dre[/url] hmfcx http://www.drdrebeatscheapest.co.uk unjro [url=http://www.drdrecheapbeats.co.uk]beats by dre[/url] xjmag http://www.drdrecheapbeats.co.uk fjtol [url=http://www.drdreoutletstores.co.uk]beats outlet[/url] yithq http://www.drdreoutletstores.co.uk qmpzc [url=http://www.drdreheadphonessales.co.uk]beats headphones[/url] iaade http://www.drdreheadphonessales.co.uk yazmc [url=http://www.cheapbeatsdrdrestores.co.uk]beats by dre[/url] wkpcd http://www.cheapbeatsdrdrestores.co.uk qfsf

  11. kuasy [url=http://www.drdrebeatsbuycheap.co.uk]dr dre beats[/url] sztrz http://www.drdrebeatsbuycheap.co.uk chskb [url=http://www.drdrebeatscheapest.co.uk]dr dre beats[/url] xrxur http://www.drdrebeatscheapest.co.uk ktsdb [url=http://www.drdrecheapbeats.co.uk]dr dre beats[/url] diyvf http://www.drdrecheapbeats.co.uk aidzv [url=http://www.drdreoutletstores.co.uk]dr dre beats[/url] bttkd http://www.drdreoutletstores.co.uk wasfj [url=http://www.drdreheadphonessales.co.uk]dr dre beats[/url] glhcx http://www.drdreheadphonessales.co.uk kpcuo [url=http://www.cheapbeatsdrdrestores.co.uk]beats by dre[/url] fkhxt http://www.cheapbeatsdrdrestores.co.uk dyhh

  12. osxmj [url=http://www.drdrebeatsbuycheap.co.uk]dre beats[/url] gexae http://www.drdrebeatsbuycheap.co.uk ydjwi [url=http://www.drdrebeatscheapest.co.uk]beats by dre[/url] isiun http://www.drdrebeatscheapest.co.uk fstvp [url=http://www.drdrecheapbeats.co.uk]beats by dre[/url] kjicp http://www.drdrecheapbeats.co.uk anmlu [url=http://www.drdreoutletstores.co.uk]beats by dre[/url] kzisk http://www.drdreoutletstores.co.uk yoyhe [url=http://www.drdreheadphonessales.co.uk]beats headphones[/url] wfxlz http://www.drdreheadphonessales.co.uk awczx [url=http://www.cheapbeatsdrdrestores.co.uk]cheap beats by dre[/url] xktpq http://www.cheapbeatsdrdrestores.co.uk nqky

  13. HabVqi [url=http://mcmnihon.com/#59491]MCM バッグ[/url] VdiAgi http://mcmnihon.com/ RxeIbd [url=http://gekiyasumcm.com/#72276]MCM バッグ メンズ[/url] RmqEqk http://gekiyasumcm.com/ IzyPpr http://cholehannbai.com/ LyyIcx [url=http://cholehannbai.com/]クロエ アウトレット[/url] FhwYuy http://uggshowbootsjp.com/ RytBnk [url=http://uggshowbootsjp.com/]ugg[/url] ClkWvf http://monclerhannbai.com/ RflCbj [url=http://monclerhannbai.com/]モンクレール ダウン メンズ[/url] TdpLre http://kuroebaggu.com/ JcnFlx [url=http://kuroebaggu.com/]クロエ キーケース[/url] WlrMxx http://saiyasunerubutan.com/ XeqNde [url=http://saiyasunerubutan.com/]クリスチャンルブタン メンズ[/url]

  17. BihNhf [url=http://kouhyoumcm.com/#52107]MCM バッグ[/url] QinLgv http://kouhyoumcm.com/ KoxJlu [url=http://waribikimcm.com/#57821]MCM 韓国 値段[/url] NyaKbm http://waribikimcm.com/ EepTqt [url=http://saisinmcm.com/#54515]MCM 財布 韓国[/url] JxnDja http://saisinmcm.com/ AuqOup [url=http://mcmyichiban.com/#00900]MCM リュック 中古[/url] CypZlu http://mcmyichiban.com/ HhjEni [url=http://suguremcm.com/#32707]MCM バッグ メンズ[/url] ZsbCpg http://suguremcm.com/ JtxCqq [url=http://mcmsaihu.com/#71383]MCM 店舗 日本[/url] PrsSsp http://mcmsaihu.com/ VmxMzw [url=http://yuuguumcm.com/#33411]MCM リュック 白[/url] YqgRtd http://yuuguumcm.com/ MycXvk [url=http://mcmdendou.com/#64185]MCM バッグ 通販[/url] RwrFnh http://mcmdendou.com/

  19. I am extremely impressed with your writing abilities and also with the format to your blog. Is this a paid topic or did you modify it yourself? Anyway keep up the nice high quality writing, it is uncommon to peer a great weblog like this one these days.

  20. PgkMlx [url=http://kouhyoumcm.com/#58103]MCM アウトレット[/url] HsnPga http://kouhyoumcm.com/ LrnQpk [url=http://waribikimcm.com/#66325]MCM 財布 新作[/url] ErgJuj http://waribikimcm.com/ TbfNfm [url=http://saisinmcm.com/#52234]MCM 店舗 韓国[/url] EjuNmi http://saisinmcm.com/ OduAwf [url=http://mcmyichiban.com/#91048]MCM 長財布[/url] KvkExn http://mcmyichiban.com/ DhqGyl [url=http://suguremcm.com/#17450]MCM バッグ[/url] ZngNdu http://suguremcm.com/ OudIai [url=http://mcmsaihu.com/#24375]MCM 長財布[/url] ZbzKdz http://mcmsaihu.com/ MsqNvg [url=http://yuuguumcm.com/#51425]MCM 財布 ヒョウ柄[/url] GjsIbg http://yuuguumcm.com/ LxiGof [url=http://mcmdendou.com/#17332]MCM キーケース[/url] WxfCyr http://mcmdendou.com/

  21. OzzJtk [url=http://mcmnihon.com/#92168]MCM 財布[/url] FcpPtq http://mcmnihon.com/ RgpTpe [url=http://gekiyasumcm.com/#07017]MCM 店舗 東京[/url] CzpZzi [url=http://ninnkisyaneru.com/#50654]シャネル 財布 カメリア[/url] RdqKqt http://cholehannbai.com/ YysLlk [url=http://cholehannbai.com/]クロエ アクセサリー[/url] JwmPdo http://uggshowbootsjp.com/ SsjYqw [url=http://uggshowbootsjp.com/]UGG ムートンブーツ[/url] RdlEzi http://monclerhannbai.com/ QwbTot [url=http://monclerhannbai.com/]モンクレール[/url] CdcP http://toumiyuuguu.com/ PygWO [url=http://toumiyuuguu.com/]TUMI 26108[/url] EljPtH http://toumionnrainn.com/ BkxHtKT [url=http://toumionnrainn.com/]TUMI 26141[/url] WyhUxt http://saiyasunerubutan.com/ GnmDpk [url=http://saiyasunerubutan.com/]クリスチャンルブタン セール[/url]

  43. I liked up to you’ll obtain performed proper here. The caricature is tasteful, your authored material stylish. nevertheless, you command get bought an shakiness over that you wish be handing over the following. ill no doubt come further before again since exactly the same nearly a lot ceaselessly inside case you shield this increase.

  45. PeyCjv [url=http://kouhyoumcm.com/#56972]MCM 財布 通販[/url] AobQdo http://kouhyoumcm.com/ FyjVom [url=http://waribikimcm.com/#77005]MCM 店舗 韓国[/url] NjcAdb http://waribikimcm.com/ HxtDff [url=http://saisinmcm.com/#82736]MCM バッグ 韓国[/url] HmxLty http://saisinmcm.com/ ZwbPkq [url=http://mcmyichiban.com/#36857]MCM キーケース[/url] OnnJcj http://mcmyichiban.com/ JkvZhz [url=http://suguremcm.com/#68179]MCM アウトレット[/url] EuvLis http://suguremcm.com/ ThzXlz [url=http://mcmsaihu.com/#56907]mcm[/url] HdaJkx http://mcmsaihu.com/ GqdKkn [url=http://yuuguumcm.com/#68499]MCM 財布[/url] WsxHxl http://yuuguumcm.com/ CiqKua [url=http://mcmdendou.com/#47765]MCM 店舗 大阪[/url] JemFji http://mcmdendou.com/

  46. YfhXof [url=http://mcmnihon.com/#63742]MCM バッグ 通販[/url] MmdUzv http://mcmnihon.com/ DfiFjd [url=http://gekiyasumcm.com/#78443]MCM バッグ 通販[/url] BlnDeq [url=http://ninnkisyaneru.com/#83443]シャネル 店舗 東京[/url] ZkoDfc http://cholehannbai.com/ PmzIdo [url=http://cholehannbai.com/]クロエ 長財布[/url] JrwIrb http://uggshowbootsjp.com/ DnyQez [url=http://uggshowbootsjp.com/]UGG 偽物[/url] NtoBfo http://monclerhannbai.com/ UuhTdi [url=http://monclerhannbai.com/]モンクレール アウトレット[/url] XsaD http://toumiyuuguu.com/ DoqEE [url=http://toumiyuuguu.com/]ビジネスバッグ TUMI[/url] BdpYjN http://toumionnrainn.com/ IzgTxKD [url=http://toumionnrainn.com/]TUMI トート[/url] ZkrDyn http://saiyasunerubutan.com/ FihAzj [url=http://saiyasunerubutan.com/]クリスチャンルブタン 財布[/url]

  49. First off I want to say fantastic blog! I had a quick question that I’d like to ask if you do not mind. I was interested to know how you center yourself and clear your head before writing. I’ve had trouble clearing my thoughts
    in getting my ideas out there. I do enjoy writing
    however it just seems like the first 10 to 15 minutes
    are generally lost simply just trying to figure out how to begin.

    Any ideas or hints? Thank you!

Comments are closed.