Hide database window, Hide menu, Disable shortcut menu, Disable Special Keys : MS Access
HTML-код
- Опубликовано: 7 фев 2014
- Make database more secure by hiding database window, hiding menu, disabling shortcut menu, disabling Access Special Keys
see related How To: www.iaccessworld.com/hide-navi... 
Хобби
Incredibly helpful! Thank you!
Very helpful. Thank you Austin.
I am so happy with your videos because it is very detailed and direct. Well done Nana
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.!
Thank you very much for sharing your techniques
You are a great guy , thanks from Istanbul
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
Thank you for sharing. Very helpful.
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.
VERY HELPFUL . THANK YOU
thanks great video helps lot.
Thank you, this helped a lot
Thank you!
Very helpful!
Thank for your sharing got lot of ideas
Can you share the coding to make the clock keeps on updating? I mean to make the seconds move every second
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!
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.
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!
How do you change the background color of the database window?
Can it be done based on access level?
I missed the last part... which key did he hold down when he double clicked on the file to open it?
if you only distribute the runtime version of access to your users then you will save the trouble of having to hide all of these things. you just have to make sure you have addressed all of your error handeling
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
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.
+austin72406 thanks. We are about 25. Not sure it will work well but thanks.
thank you, i love you, my god.
Thank you sir
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!?
thank you very much
is there a way to disable quick access toolbar in print preview
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/
lovely thankyou
its great but can i have a sample of this code procedure
Austin much easier way is to change the extension of your access file from .accdb to .accdr. Now all the menu will be disabled
Why does this method not work with Access 2016?
Can Someone tell me the shortcut key of design View
Good video, thanks. But the bypass at the end was not clear, can you clarify please!?
+mhjrt If you hold down the shift key when opening the the database, it will enable the navigation pane/ribbon/shortcuts.
haha yes. but I guessed it he mean to say SHIFT KEY :) grt video.
THe navigation thing is gone now .. but i dont see the options to change it now. How do i bring it back
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!
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.
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!
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.
austin72406 Thanks! Please mail to Nguycong.vn@gmail.com.
I try to use in my project, unfortunately, file was not found . Can anyone help me please?
Sir kindly make video on ms access accounting system
please write me about clock on the right corner
Nice
من فضلك أريد كود برمجي لمنع تغيير وقت وتاريخ الجهاز بالاكسس ...
How to disabble the ribbon menu but not the quick access menu?
DoCmd.ShowToolbar "Ribbon", acToolbarNo
put it on Load Event
What? That's exactly what the video shows. I'm asking how to hide the ribbon menu but not the quick access menu.
Sir, how to normalise it?