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.
Microsoft Office Access 2007 provides security features ...