• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1489
  • Last Modified:

Startup options with shift key in Access 2002

Hi, I wrote an access app a few years ago and have forgotten how I put the Shift Key option on startup in Access.  That is, the app runs and opens a form, but the user cannot modify.  I know this is pretty stupid, but How do I restore the Access app so the startup doesn't need the shift key to allow the user to mess with the tables?  I don't see any macros that are used in the load form event.  
  • 2
1 Solution
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
This link will show you how to do it:


Remember, however, that you'll have to re-enable the shiftkey, then close and reopen the app. Specifically, you'd need to copy both code modules you find at the link, then run it like this from the Immediate window:

?ChangePropertyDDL("AllowByPassKey", dbBoolean, True)

You can get to the Immediate window by pressing Ctrl + G
> so the startup doesn't need the shift key

I think it's more simple:
* open once with Shift
* choose "Tools / Startup..."
* reenable all needed checkboxes, perhaps remove the form
* close
* choose "Tools / Options"
* enable viewing of hidden objects
* close and check if you have an AutoExec macro
* if you do, rename it

That would be all, I think
Good luck!
DLJAuthor Commented:
This worked fine.  THanks for the quick response.
Glad I could help. Good luck!

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

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