Avatar of Clive Beaton
Clive BeatonFlag for Australia asked on

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

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.
Microsoft Access

Avatar of undefined
Last Comment
conagraman

8/22/2022 - Mon
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

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.

mx
ASKER
Clive Beaton

mx

Can you tell me how to hide it?
ASKER CERTIFIED SOLUTION
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
TommySzalapski

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.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
ASKER
Clive Beaton

Brilliant.  Thanks.  The code in the app start did it.
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

Do you have a custom menu and does it show?

mx
ASKER
Clive Beaton

mx,

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.

crb
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

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.

mx
conagraman

try this
access options>>current database>> document window options
select document "tabbed Documents"
uncheck "display Document tabs"
ee2.bmp