O'Reilly logo

Access™ 2007 VBA Programmer's Reference by Armen Stein, Geoffrey Griffith, Rob Cooper, Teresa Hennig

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 18. Database Security

Microsoft Office Access 2007 provides a range of security features to meet the needs of most database applications. These security features break down into two categories: database security for the ACCDB file format, which is discussed in the first part of this chapter, and database security for the MDB file format, which is the focus of the rest of the chapter. This chapter discusses the various methods available to secure your Access database applications using VBA code in either file format.

Be aware that several of the security features available in the MDB file format are not available in the ACCDB file format, and vice-versa. For the ACCDB file format portion of this chapter, you'll examine databases encrypted with passwords and code secured by either compiling the database or locking the modules. For the MDB file format portion, you'll explore shared-level security, user-level security, database encoding, MDE files, and using VBA to manipulate security. There's also a discussion about user-level security and the detachment between the MDW file and the secured database application file.

It is important to understand all of the various types of security in both file formats to fully comprehend the implications of the security model being employed by the database. The recommendation is to read this entire chapter before deciding which method of security is best for the database application.

NOTE

Microsoft Office Access 2007 provides security features ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required