Can I hide the File Tab or limit the functions on it?

Posted on 2010-11-09
Last Modified: 2012-05-10
Can I hide the File Tab or limit the functions on it?

Surely Microsoft don't expect us to distribute an application database where the user can   Mange Permissions, set database passwords, etc.

Thanks in advance.
Question by:CRB1609
LVL 75
ID: 34099427
So far, with an ACCDB, I've been able to hide the File tab, but ... my custom menus from A2003, which would be on the Add-In ribbon ... do not appear.  Would love to see a solution.


Author Comment

ID: 34099440

Can you tell me how to hide it?
LVL 75

Accepted Solution

DatabaseMX (Joe Anderson - Access MVP) earned 500 total points
ID: 34099473
As far as I remember, there are the settings.
This is an A2010 ACCDB, converted from an A2003 mdb.
As noted, however ... my custom menu does not show up, so this will not work for me

Also, in my app start up code, I also have this;

DoCmd.ShowToolBar "ribbon", acToolBarNo.

LVL 37

Expert Comment

ID: 34099679
Also you should be able to set the permissions so that if they click on any of those things it gives them an "Access Denied" error. You can hide all the menu items you want, but they can unhide them if they know how.
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.


Author Closing Comment

ID: 34099715
Brilliant.  Thanks.  The code in the app start did it.
LVL 75
ID: 34099719
Do you have a custom menu and does it show?


Author Comment

ID: 34099799

I do have a custom menu and it does NOT show.  I will have to put my menus on a button on each form if I can't find a way to remove them from the File tab programatically.  But that's for another question.

LVL 75
ID: 34099816
We *need* to find a way ... and there *must* be a way ...
I have 25 mdbs at work, all with custom menus, toolbars and right click popups ... and we are deploying O2010 by year end. So, putting menus on a form is not an option for me.  And some menu items are app specific, not form specific.

Anyway ... this is a start.

LVL 10

Expert Comment

ID: 34115692
try this
access options>>current database>> document window options
select document "tabbed Documents"
uncheck "display Document tabs"

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article is a continuation or rather an extension from Cascading Combos ( and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

947 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now