Hide database window, Hide menu, Disable shortcut menu, Disable Special Keys : MS Access

Make database more secure by hiding database window, hiding menu, disabling shortcut menu, disabling Access Special Keys
see related How To: www.iaccessworl...

[@KingsleySundayOA]

I am so happy with your videos because it is very detailed and direct. Well done Nana

[@ninocunanan523]

Hi Austin! thank you for your great tutorial. I would like to ask what is the code for hiding the navigation pane. I want to run it on the "user only" form. Thank you sir.!

[@danielrobinson6127]

Incredibly helpful! Thank you!

[@zibusisondlovu5127]

Very helpful. Thank you Austin.

[@aydinbulent]

You are a great guy , thanks from Istanbul

[@AndreChampoux]

Thank you, this helped a lot

[@taiflightmoon6411]

VERY HELPFUL . THANK YOU

[@SamA-jg8vy]

I missed the last part... which key did he hold down when he double clicked on the file to open it?

[@piaggiokpt]

Thank you very much for sharing your techniques

[@Omkh4258]

One question, after I disable everything, what is a quick way to regain access to the database options which are now more or less inaccessible? All I have left that is visible is the top application bar "Microsoft Access" gray border with no shortcut keys enabled, or right clicking. Thanks for the great video!

[@austin72406]

you can call the enable function from any place on your form. for example, call enable function under the Double click of certain word on your form. just remember that word. close and re-open after enable all function.

[@BonChisamba]

If i dissable all trusted macros i get full access since it asks me to enable them to run. But what i was looking for was how to disable "Options button and Privacy options button" on the current database.

[@sidhpillai]

Austin much easier way is to change the extension of your access file from .accdb to .accdr. Now all the menu will be disabled

[@sherylenedyer2076]

Thank you for sharing. Very helpful.

[@besnikem]

I have a database app with access butt the Shift key and double click doesn’t enable it and i can do that i try to copy the access database into another follder to try it butt it is the same it doesn’t enable it! Do you have any solution for it!?

[@Nate-xd8bq]

Can you share the coding to make the clock keeps on updating? I mean to make the seconds move every second

[@johnlivingstone5796]

Thank for your sharing got lot of ideas

[@debdeepnanda3567]

Can it be done based on access level?

[@mhjrt]

Good video, thanks. But the bypass at the end was not clear, can you clarify please!?

[@lvlrSmooth]

+mhjrt If you hold down the shift key when opening the the database, it will enable the navigation pane/ribbon/shortcuts.

[@me2000]

haha yes. but I guessed it he mean to say SHIFT KEY :) grt video.

[@slyowusu99]

Hello Austin. question. what is the best way to create an Annual leave booking simple DB on Access 2003? For a few staff members to ensure we all do not take leave at the same time. thanks

[@austin72406]

since you have only few staff then you can use Outlook calendar to list the member off on each day. it should cover your needs.

[@slyowusu99]

+austin72406 thanks. We are about 25. Not sure it will work well but thanks.

[@deveroseven7976]

This was very helpful. Thank you so much.....however...... if you watch your video again with CC (Close Captions) on.... I laughed my face off.... Thank you X2!

[@javatea111]

Hi all, I have been struggling to secure my database application. I manage to secure it. Once I done my settings I myself are unable to hack into it again.I made sure I have a copy of original before doing my settings.The bypass shift do not work and the Ctrl+G that open the Immediate window does not work. Thanks

[@Marakez]

Why does this method not work with Access 2016?

[@mks2613]

thanks great video helps lot.

[@sivaramakrishnanvenkatasub5253]

THe navigation thing is gone now .. but i dont see the options to change it now. How do i bring it back

[@joelast8503]

Very helpful!

[@chongyolbaik3929]

How do you change the background color of the database window?

[@mahfoudbouabdallah6286]

thank you very much is there a way to disable quick access toolbar in print preview

[@austin72406]

we have the question and answer here: www.iaccessworld.com/question/how-to-disable-the-privacy-options-customise-quick-access-toolbar-residing-on-the-office-button/

[@AliTwaij]

lovely thankyou

[@abdulhadimateen4490]

its great but can i have a sample of this code procedure

[@worldtextile7342]

Dear Austin, i'm struggle on the bypass key. even i disable the bypass key but when i open another access file then create a function to enable the bypass key in another database, it work. for example i disable the bypass key in access file name test_1, then i open another access file name abc,,, then create a button link to test_1 database and enable bypass key function in test_1 database it work too. How can i prevent this? right now i could't find any solution for this matter. Please help. thanks!

[@austin72406]

disable bypass key is to set property of MS Access program in that PC, not for individual Access file. That's why we have to put the disable bypass key function on the main form on the On Load Form event. Each time program is loaded then it will disable the bypass key.

[@worldtextile7342]

austin72406 So disable bypass key is useless? cuz anyone have some knowledge about acceess can enable it easy. i was very happy when i found you video about disable bypass key but then i found out simple way to enable bypass key. could you recommend a more secure way for access file? i want to protect the table. of course i do all secure you show us on you tube. user lever, login on starup, hide the ribon... but come back from beginning because of this bypass key. please help thanks!

[@austin72406]

Disabled bypass key is still useful. It will disable access file every time when open file if you put code on load event. Even you enable it on another file and open another file it will disable a new file because the disable function is put under the On Load of new file. Please provide me your email I will send you a sample file.

[@worldtextile7342]

austin72406 Thanks! Please mail to [e-mail].

[@Raine_Daily]

Thank you!

[@ulayaz]

I try to use in my project, unfortunately, file was not found . Can anyone help me please?

[@จ่าเขียว-น7ฦ]

Thank you sir

[@FahadKhan-vd2hd]

Sir kindly make video on ms access accounting system

[@prince030896]

thank you, i love you, my god.

[@yalcnsofulu675]

please write me about clock on the right corner

[@doctordri]

How to disabble the ribbon menu but not the quick access menu?

[@austin72406]

DoCmd.ShowToolbar "Ribbon", acToolbarNo put it on Load Event

[@doctordri]

What? That's exactly what the video shows. I'm asking how to hide the ribbon menu but not the quick access menu.

[@apunbadhirawamgungahai8471]

Can Someone tell me the shortcut key of design View

[@bck4589]

Sir, how to normalise it?

[@AliAli-is8md]

من فضلك أريد كود برمجي لمنع تغيير وقت وتاريخ الجهاز بالاكسس ...