Chapter 2: Protecting Your Database with Startup Options


Overview

If there's one chapter in this book that will help you protect your database, this is it. The startup options are simple and important safeguards that will hide the Database Window and Access programming commands and disable special keys used to access the developer's environment. These options apply to the current database and apply the next time the database is opened.

The low-risk steps required to modify the database startup options with menus are quick and easy. Once you've turned off the options, the data and application objects are less accessible to the average user. For the user , some of these changes provide a less-cluttered interface that should make your application easier to use.

The demonstration material for this chapter includes the following:

  • An Access form that allows you to change the startup options. This form is very useful when the menu item to display the Startup dialog is disabled.

  • Visual Basic for Applications (VBA) code within that Access form that will show you how to change the startup options.

  • VBA code within that Access form that will disable the AllowBypassKey property, an option that is not available from the menus. This code ensures that the user cannot change the startup options.

  • Accelerator keys that you can use when the developer menus and toolbars are disabled.

Note  

To find the demonstration material, open the download database for your version of Microsoft Access ”for example, grMAP97.mdb ”and select Chapter 2.

I'll begin the chapter with an overview of the startup options.




Real World Microsoft Access Database Protection and Security
Real World Microsoft Access Database Protection and Security
ISBN: 1590591267
EAN: 2147483647
Year: 2003
Pages: 176

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net