Solved

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

Posted on 2010-11-09
9
1,758 Views
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.
0
Comment
Question by:CRB1609
9 Comments
 
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.

mx
0
 

Author Comment

by:CRB1609
ID: 34099440
mx

Can you tell me how to hide it?
0
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) 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.

mx
NoFileTab.jpg
0
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

 
LVL 37

Expert Comment

by:TommySzalapski
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.
0
 

Author Closing Comment

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

mx
0
 

Author Comment

by:CRB1609
ID: 34099799
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
 
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.

mx
0
 
LVL 10

Expert Comment

by:conagraman
ID: 34115692
try this
access options>>current database>> document window options
select document "tabbed Documents"
uncheck "display Document tabs"
ee2.bmp
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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.

Question has a verified solution.

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

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

828 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