Chapter 11: Object Protection and Security Measures


Overview

Protecting and securing the objects in your database are best handled by workgroup ( user -level) security or by converting the database into MDE format. To that end, I discuss and review these important topics in more detail in this chapter. As usual, Access's flexibility means that there are more issues related to protecting objects that are worth exploring. Bearing these issues in mind, I have put together an eclectic mix of additional protection and security measures that will supplement or act as an alternative to workgroup security and the MDE database format. The material presented in the chapter will help you to

  • Review workgroup object permissions and create the developer workgroup file by demonstrating the User-Level Security wizard.

  • Hide links to other databases or files.

  • Secure the design of your queries.

  • Protect forms and reports from being opened in design mode in an unsecured database.

  • Show you how to use workgroup security with data access pages.

  • Discuss Access data project security.

  • Give more details on the MDE database format.

The download material for this chapter includes forms and Visual Basic for Application (VBA) examples that will

  • Stop anyone from opening a form or report in design mode.

  • Open a form in such a way that VBA code hides the form's record source.

  • Convert the current database to MDE format.

Note  

To find the demonstration material, open the download database for your version of Access (for example, grMAP2002.mdb ) and select Chapter 11. Before running any samples that involve data, you may need to relink the tables to the Northwind database on your computer.




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