Access 2016 Front End, MDB back end (1 Viewer)

[MW4]

I have a long running MDB database that we are porting over to a SQL backend, but that is probably a year down the road.

We have been using an MDB-->MDE front end/MDB back end utilizing Access 2003.

We are now moving to Access 2016.
My plans are to continue with the MDE --> MDB Front / MDB Backend (user security in place) until we fully move to SQL backend.

Then as we move along an ACCDB ACCDE front end / SQL backend.

Ok, now my question...

I want to only show the home "tab" in the ribbon.
How do I set that up in VBA in my MDB front end?

 

[isladogs]

AFAIK you can't hide the File tab.
The minimum you can have is File...Home

To do this go to File..Options...current Database
Then untick 'Allow Full Menus'

I would also suggest you untick Show Navigation Pane

However it is possible to hide the menu completely.
This will also hide the ribbon and quick access toolbar.
For example:

Obviously this means you need to include all necessary functionality within your db.

If you are interested in the latter option, let me know & I'll reply tomorrow.
WARNING: this requires a good understanding of VBA code

 

[George Moore]

If you give users enough rope they will probably hang themselves so although you can't hide the File Menu you can use VBA to restrict what appears at run time.

I also use a custom Ribbon to hide lots of built in commands to avoid any user being "innovative"

All the built-in commands are re-enabled when the user quits the front end

I can supply code if that is what you are after

Screenshots attached