Skip to Main Content
Microsoft® Access® 2010 Programmer's Reference
book

Microsoft® Access® 2010 Programmer's Reference

by Teresa Hennig, Rob Cooper, Geoffrey L. Griffith, Jerry Dennison
August 2010
Intermediate to advanced content levelIntermediate to advanced
1272 pages
32h 43m
English
Wrox
Content preview from Microsoft® Access® 2010 Programmer's Reference

Chapter 24. Database Security

WHAT'S IN THIS CHAPTER?

  • A description of the database security features available in Access 2010

  • A discussion of security features of the ACCDB file format

  • A discussion of security features of the MDB file format

  • Step-by-step instructions for using each of the database security features in Access 2010

  • VBA Code Samples for manipulating security features programmatically, where possible

Microsoft Office Access 2010 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 second part of the chapter. This chapter discusses the various methods available to secure Access database applications using VBA code in both the ACCDB and MDB file formats, which have some very important differences. Be aware that several of the security features available in the MDB file format are not available in the ACCDB file format. For the ACCDB file format portion of this chapter, you'll examine encrypting databases with passwords and securing code 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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Access™ 2007 VBA Programmer's Reference

Access™ 2007 VBA Programmer's Reference

Teresa Hennig, Rob Cooper, Geoffrey Griffith, Armen Stein
Excel® 2007 VBA Programmer's Reference

Excel® 2007 VBA Programmer's Reference

John Green, Stephen Bullen, Rob Bovey, Michael Alexander
Professional Access 2013 Programming

Professional Access 2013 Programming

Teresa Hennig, Ben Clothier, George Hepworth, Dagi Yudovich

Publisher Resources

ISBN: 9780470591666Purchase book