Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1981
  • Last Modified:

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.
0
Clive Beaton
Asked:
Clive Beaton
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
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
0
 
Clive BeatonAccess DeveloperAuthor Commented:
mx

Can you tell me how to hide it?
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
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.

mx
NoFileTab.jpg
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
TommySzalapskiCommented:
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.
0
 
Clive BeatonAccess DeveloperAuthor Commented:
Brilliant.  Thanks.  The code in the app start did it.
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Do you have a custom menu and does it show?

mx
0
 
Clive BeatonAccess DeveloperAuthor Commented:
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
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
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
0
 
conagramanCommented:
try this
access options>>current database>> document window options
select document "tabbed Documents"
uncheck "display Document tabs"
ee2.bmp
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now