I have developed a simple application program using access 2016. I have succeeded in customizing the tabs and ribbon. I now want to get rid of the quick access toolbar so that no body can access the access option to change any thing from my database.
A codeline - DoCmd.ShowToolbar "Ribbon", acToolbarNo
removes the QAT as well as the ribbon. But I want to retain the ribbon but only QAT to be removed. Please help me, how can I do it?
12 20882 zmbd 5,501
Recognized Expert Moderator Expert
In your Ribbon XML include the line: <ribbon startFromScratc h="True">
Insert this as the first line after the namespace <customUI xmlns=....
>> NOTE:
1) This will hide all of the Ribbon interface so make sure your users have everything they need.
2) Any knowledgeable user can bypass this.
-z
Thank you for the suggestion. I am sorry I could not reply your post earlier due to some domestic problems. As you have mentioned that any knowledgeable user can bypass this. Please, how to bypass this?
Is there no option to show the custom ribbon? please
The actual need is to restrict the access of the user to the access options so that he may not alter the settings to show the navigation pane etc.
zmbd 5,501
Recognized Expert Moderator Expert
I don't typically discuss how to bypass even this minimal security, just not good form.
Make a copy of your database
Using the copy:
Open the VBA editor, <alt><F11>
In the project explorer, at the top of the tree, right-click.
In the shortcut menu there will be an option with your database name and "properties " - select
In the dialog that opens [Protection] Tab
Select [Lock project for viewing]
Set the password
>>> ABSOLUTLY REMEMEBR THE PASSWORD
>>> Share it with another person or two, send it in an email to someone. Just DO NOT LOSE the password and make sure that it will be available to the people that follow you in case you ever leave and they need to maintain the code. The password can be cracked; however, it's a real pain to do.
SAVE
Still in the VBA editor
Menu>Debug>Comp ile
Make sure you have fixed any and all errors this turns up.
Repeat until the Compile completes without error.
SAVE
Close the editor
Ribbon>Database Tools>Tools>Com pact and Repair
When things settle down.
Close the database and re-open
Ribbon>File>Opt ions>Current Database> ::
::>Application Options> uncheck [Use Access Special Keys]
::>Navigation> uncheck [Display Navigation Pane]
::>Ribbon and Toolbar Options
[Ribbon Name] set this to your custom ribbon that you want available on open.
uncheck [Allow Full Menus]
uncheck [Allow Default Shortcut Menus]
Make sure your code and forms run correctly.
Male sure that your ribbons show up and function correctly.
These settings along with <ribbon startFromScratc h="True"> in the custom ribbon will make it a nuisance for the average user to meddle with things.
You can then make the ACCDE (executable version) from this version of the database. This then makes it very difficult to meddle with things, even for an experienced user such as myself.
If you have not done so, splitting the database to front and back ends is a good idea for this environment. I will often encrypt the back-end and then link the tables. I'm not too worried about the password being stored in the links to the encrypted back end for my applications and the users I have are not typically interested in prying thru the front-end to find the password.
Is there no way to keep my custom ribbon and hide/disable the QAT button at the same time in ms access application?
zmbd 5,501
Recognized Expert Moderator Expert
the start from scratch option removes all of the built-in ribbons, including the QAT.
@zmbd
i don't think it does, the QAT is still there, you can't add buttons to it but the line for it is there with just 1 button LINK OBJECTS
i'm trying to get this space back while keeping the custom ribbons
heres a link to the screenshot, cant figure out how to add an image https://ibb.co/rdhXwPV isladogs 459
Recognized Expert Moderator Contributor
@nata4444
Until a couple of years ago, the ribbon and QAT were completely inseparable. You either had both or neither.
However, if you have Access365, this has now changed and you can now have ribbon or QAT if you wish.
Screenshot to follow shortly
BTW Your screenshot shows the QAT after it has been disabled. You can re-enable the QAT and remove that item if you wish.
See my article: Securing your database - a tutorial
Fellow dog lover :) gorgeous one in your screenshot. I have 2 shepherds, I can't make out what yours is
Very useful article, I learned a bunch. Will try the qat part.
I do have the qat disabled but I'm not sure why. This happens once I load custom ribbons. Any idea what's locking it?
From your article, few comments on locking the db, I haven't found any reliable way that I wasn't able to bypass. I think the only one is the encryption with no strings. Everything else - i was able to find a way to get to the tables from another db
To me it hasn't been an issue, I haven't had a project where I was asked to lock it down completely, so I haven't messed with it much.
Also, didn't know about deep hidden tables.
Thank you very much
isladogs 459
Recognized Expert Moderator Contributor
@nata4444
1. This was the Access365 ribbon options screenshot I mentioned before:
2. No Access database can ever be completely secure from a determined and skilled hacker with time on their hands.
The article I mentioned is outlining ways of improving security and is sufficient for almost all circumstances.
Agree totally that if you know how, almost any security can be bypassed.
In general, if your data is that sensitive, it shouldn't be stored in Access.
However the encrypted split no strings approach is about as secure as any Access app can ever be.
You can easily test it for yourself by trying to crack the example app provided.
So far, nobody has mentioned to crack it using VBA
3. Section 5 c) of that article explains what causes the QAT to be locked. I've even highlighted it in RED
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: u7djo |
last post by:
Hi,
I'm currently building an application in Access and as part of this
need to import forms and modules from another database. Some of the
imports will be revisions of existing forms/modules so I need to check
and see they already exist before importing them so I can remove the
old one.
I've figured out how to remove the classes and modules before importing
the revised version but I'm having problems with the forms. I was
hoping to use...
|
by: matvdl |
last post by:
My asp.net application depends on obtaining allot of data from a remote
application. This application is a bit of a monster and it is not an option
to install it on the asp.net system. Note - the remote application is
developed in vb6
Currently I have the application installed on a number of remote computers
and use DCOM from asp.net to communicate with this application. All the
calls to this remote application are generally kept to a...
|
by: Wayne |
last post by:
I've searched this forum and trawled the wider web and can't find any
information on how to hide or disable the A2007 Quick Access Toolbar.
The toolbar is not something that one wants available to the user in a
custom application.
Can it be disabled or hidden and if so, how?
|
by: dstork |
last post by:
In Access 2007, does anyone know of any code to position the QAT below
the ribbon? This can be done manually but what about through code?
ds
|
by: Bob |
last post by:
Hi,
Can it's possible to use a customized QAT in Access 2007 with a Ribbon using
"USysRibbons" ?
because in Access options i can't select 2 ribbon name.
Thank's
| |
by: Heather |
last post by:
I keep selecting and selecting, but it just doesn't show up. I also
have no button in the ribbon for this, or any ability to get into
other modes via the Office button. It's very frustrating; I had to
search online for a keyboard shortcut to be able to access Design Mode
at all.
I'm sure there is something I'm missing, but it doesn't make sense. I
can add and remove other buttons from the toolbar, why not Mode??
|
by: convexcube |
last post by:
Hi everyone,
I am trying to create a single window interface for my database. As I am using Access 2007, I have my document layout options set to tabbed documents without displaying documents tabs in order to get my main form to appear as the only element in the access application window. I have also set anchoring in the form so that controls that should always be visible are and others stretch to adjust to the size of the window. When...
|
by: Karen Waddell |
last post by:
How do I stop Access from deleteing or resetting the QAT for my application (not the User QAT, but rather the QAT that is attached to the current database). I have created this qat about 20 times -- it stays visible for about 4-5 open and closes of the database, but then unexplainably disappears. I have commands and macros on the toolbar. This is unbelievably frustrating. It worked perfectly in Access2007 but after upgrading recently, I see...
|
by: sun50 |
last post by:
I develop a simple application programme using access 2007. I have succeeded in removing the tabs and ribbon. I now wanted to get rid of the quick access toolbar so that no body can access the access option to change any thing from my database. Please help me, how can I do it?
Thanks.
|
by: Hinson3 |
last post by:
Hello all,
I need a solution similar to the Microsoft Customize Quick Access Toolbar dialog. Where you select the item from one side | Click Add and the selected item is copied to the selected item list/box. You repeat the process until all items that apply are selected. Then Click OK and the selected items (PrimaryID) are copied/added to a table/query.
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |