Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.


  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 18. Database Security

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.


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint