How To Disable/Enable the Shift Bypass Key in Microsoft Access
Is there any way of preventing user's from holding down Shift Key when opening up my Microsoft Access database and bypassing the Start-Up options which have been disabled. I however, still need some sort of facility to do this, so I can add new forms, queries etc. whenever necessary.
Thank you for taking the time to report an issue.
What's wrong... Please write below.
I know that I can startup MS-Access manually and bypass the startup options, including any macro that is set to run automatically, by holding the Shift key down when launching the application. What I need to know is how to do this in a vb program. I have:
Public Sub AccessStuff()
Dim myaccess As New Access.Application
Dim db = myaccess.CurrentDb()
which works nicely and opens the database just fine. However, this mdb has a startup macro defined in it. I can't hold down the Shift key since I'm doing this from a program. In thiscase, how can I bypass the startup macro?
Which is placed behind two command buttons on an opening form.
When I press the cmdDisableSHIFTKey button and close the db and then open it, the db window still appears. I'm using Access 2010.
I have a database that has been split in to a front and back end. I have the front end set up so to work on it I hold the shift key to open it. All of a sudden holding the shift key does nothing and I get to the user window only.
I have tested this on another computer and the database works correctly there - opens to working area with the shift key. AND I have tested another database on this system and it ignores the shift key.
Does anyone have any idea how I could have disabled the shift key for one system only? I have to deliver this version to the client in the morning.
In my Microsoft Access database I have a table of Users, each with a user name and password, and a login form set up. I want the user name and password entered into the login form to be compared against those stored in the Microsoft Access table. If a match is found the user is allowed to access to the system, if not the system should exit.
Answer » The following details one procedure that could be applied to this scenario. There are many more approaches to this and also other areas that will need to be secured within your database environment. You should also look into Disabling/Enabling the Shift Bypass Key.
In Access 2003/XP/2000/97, I've secured a database using the User-Level Security Wizard and I've also hidden the Database window in the Startup Options for the database. However, when a user logs in while holding down the Shift key, the Startup Options are not bypassed and so the Database window will not appear.
In Access 2003/XP/2000/97, I've secured a database using the User-Level Security Wizard and I've also hidden the Database window in the Startup Options for the database. However, when a user logs in while holding down the Shift key, the Startup Options are bypassed and the Database window appears.
This article is about macro security and explains the risks of enabling macros and how the Trust Center in the 2007 Microsoft Office system can help to mitigate these risks.
In this article:
* What is a macro and what is the security risk?
* Enable or disable macros with the Trust Center
* How can the Trust Center help protect me from unsafe macros?
* A security warning asks if I want to enable or disable a macro. What should I do?
Microsoft Access 2007 will disable your code and macros unless you enable it or add your database location as a trusted location. This will show you how to do it.
I have a database that has a form front-end. I want to lock down the database so that nobody can access the forms/VBA code attached to it (tables are are in a separate database). I did this by setting startup options so that menus are hiddens, hidden keys etc.
However, I just found out that when you press shift and double-click on the database to open, it opens up the database with menus etc unhidden.
Is there a way to stop full menus being displayed when you press the shift key and double-click?
I'm trying to make an internet cafe billing application using Microsoft Access. Any one can help me how to disable ALT+TAB, CTRL+ESC, and Windows button function using access VBA? I can do that in VB using SetWindowsHookEx API function.
But in access vba it's not running well because the variable/object/property "App" does not exist in Microsoft Access. There is theway to do that in Microsoft Access VBA?