How to disable table tools and properties in access

Question

Please In need help on how I can disable table tools and properties shown in the attache photos. Thank you.

Answer 1

For the first, you could hide the navigation pane. In the OnOpen event of your switchboard add:

DoCmd.NavigateTo "acNavigationCategoryObjectType"

    DoCmd.RunCommand acCmdWindowHide

Or go to file, options, current database and uncheck 'display navigation pane'

For the second, You can locate the tab by going to file, options, customise ribbon... then remove the items. It will look something like:

you could also research creating your own custom ribbon

another option is to add the following to the OnOpen event of your switchboard:

DoCmd.ShowToolbar "Ribbon", acToolbarNo (this will hide the ribbon completely)

Answer 2

Hi George, I'm an independent adviser and will try to help.

What it sounds like is you don't want to let users get into Design mode for your tables. If so there are a couple of things you can do. First, is to hide the Navigation pane so users cannot see the objects and get into the properties. This is done under File>Options. In the Current Database tab you can set to hide the Nav Pane. Users should never have direct access to tables. All data entry should be done through forms. Another thing that can be done is to compile the database into an ACCDE before deploying to users. This removes access to all Design elements. This is done under File>SaveAs. Another thing you can do is make a Custom ribbon. This is more complex and requires some programming. Here is one article on that; https://docs.microsoft.com/en-us/office/client-...

There is more that can be done to secure your Access application. A search on Securing an Access application will find more options. My blog article on Login Security with VBA (scottgem.wordpress.com) is one source. This link is to a page on my website. It is safe. I am providing it because I think it contains information that will help you. However, as an Independent Advisor I am required to add the following when posting here with a link to any non-Microsoft site: Please Note: This is a non-Microsoft website. The page appears to be providing accurate, safe information. Watch out for ads on the site that may advertise products frequently classified as a PUP (Potentially Unwanted Products). Thoroughly research any product advertised on the site before you decide to download and install it.

If you need further clarification on this please feel free to ask.