Remove Privacy Options in Access 2016

Question

Does anyone know how to remove the privacy options in Access 2016? I have tried using the USysRibbons option and inputed the following:

[<customUIxmins="http://schemas.microsoft.com/office/2009/07/customui"> <ribbon startFromScratch="false"></ribbon></ribbon> </backstage><button idMso="ApplicationPrivacyOptionsDialog" visible="false"/></backstage>                                                 </customUI> ]

Which works for MS Access 2013, but in Access 2016, it shows Privacy Options when you disable everything else, allowing any of my users to have access to tables and such that I don't want them to. 

If anyone has a solution please let me know, Thank You.

Answer 1

The code I posted above, hides the navigation pane, so that unfortunately isn't the issue. The issue is that after entering the code as above, when the user goes to the file tab it should only show feedback, print and close. However; ms 2016 was set up in a way that when you hide the options in the file tab, it will instead show Privacy options, which is the same as options (just with a different name). I'm wanting to hide all options, so that way once I hide everything the user cannot go into options and reset them to be able to access everything in the database.

If you watch this YouTube video it explains: https://www.youtube.com/watch?v=i1n7H686bWI

So the solution I need, is just to hide the privacy options. As everything else was hidden with the code as it was supposed to.

Answer 2

Fille the steps in http://www.devhut.net/2016/09/01/securing-your-ms-access-database-front-end/To lock down your front end.

Answer 3

Fille the steps in http://www.devhut.net/2016/09/01/securing-your-ms-access-database-front-end/To lock down your front end.

The link, doesn't explain how to hide the privacy options. If you could send me a link to hide the privacy options, not just options, or just tell me the solution, that would be much appreciated.

Answer 4

Indeed the link doesn't, but it does cover the steps to secure your database, including hiding the navigation page, which is what you want i believe.

The direct code for hiding the navigation pain can be found at

http://www.devhut.net/2011/05/25/ms-access-vba-hide-nav-pane/

This step alone protects you from users accessing various database objects besides those you make available to them.

Answer 5

What you want to do can be archived by hiding the navigation pane :

(1) A code will be required here which will allow to hide the navigation pane and also allow  you to enter through the back door

Because of the IP issues here I'm not able to post the code , please buy a book from Amazon written by Garry Robinson on Access security and protection I may  not have gotten the title properly but it is in those lines , what that book will do to you are as follows:

(1) Show you how to create a new ribbon like what you are suggesting above

(2) A code to hide all the objects

(3) How to create a back door key , if you do not create a macro key to allow you disable the hide code it means that you will rocked out permanently

(4) Protecting  ( Queries , forms , reports & VBA modules)

(5) It will also show you how to create a proper start up form which very essential for your application

I was in that situation before , the above book saved me a lot , I'm also using Ms Access 2016 , the codes there works well.

Remember , the only gold key we are given is to create an accde copy after development.

Regards

Chris