Real World Microsoft Access Database Protection and Security - page 1
- Table of Contents
- Table of Contents
- BackCover
- Real World Microsoft Access Database Protection and Security
- Foreword
- Chapter 1: The Access Protection and Security Driving Instructions
- The Overall Road Map
- Your Personal Driving Instructions
- About the Book and the Demonstration Material
- Secure Things that You Can do Now
- Does Upgrading Assist in Security?
- Further Reading
- Security: The Journey Never Ends
- What s Next?
- Chapter 2: Protecting Your Database with Startup Options
- Do I Need to Read this Chapter?
- Manually Changing Startup Options
- Programming the Startup Options
- The AllowBypassKey Property
- Using Homemade Accelerator Keys in Restricted Environments
- Further Reading
- Reflecting on this Chapter
- What s Next?
- Chapter 3: Using Database Options and Attributes to Protect Data and Objects
- How Will this Chapter Help Me?
- The Protection-Related Database Options
- Hiding Objects in the Database Window
- Further Reading
- Reflecting on this Chapter
- What s Next?
- Chapter 4: Providing a Solid Foundation with Good Programming Practices
- Is this Chapter Worth Reading Now?
- The AutoExec Macro Provides a Flexible Springboard
- Splitting Your Database to Make it Easier to Protect
- Error Handling Shields Your Code
- Further Reading
- Reflecting on this Chapter
- What s Next?
- Chapter 5: Backing up and Recovering Your Databases
- What You Must Know About Database Backups and Recoveries
- Backing up Multi-User Databases
- Normal Backups
- Creating Compressed (.ZIP) Archives
- Compacting Databases
- Saving Tables to Text Files
- Exporting and Recovering Programming Objects
- Size Does Matter: How the Text Backup Files Will Help
- Backing up Other Information
- Backing up Your Database by using Access 2003
- Further Reading
- Reflecting on this Chapter
- What s Next?
- Chapter 6: User and Object Surveillance
- Will Surveillance Really Help?
- The Jet User Roster Form
- The LDBView Utility
- The Access Workbench
- Logging Windows Users, Computers, and Access Accounts
- Recording When Objects are Opened
- Retrieving the Computer Name, Windows User ID, and Access Workgroup ID by using VBA Code
- Checking for Users Who Skip the Startup Sequence
- Further Reading
- Reflecting on this Chapter
- What s Next?
- Chapter 7: Protecting Your Database with Menus and Toolbars
- Will Menus and Toolbars Help Protect My Database?
- Building Toolbars, Menus, and Shortcut Menus
- Integrating Menus into Your Forms and Reports
- Modifying the Built-In Menus and Toolbars
- Further Reading
- Reflecting on this Chapter
- What s Next?
- Chapter 8: Developer Workgroup Security
- Why is Developer Workgroup Security so Important?
- The Developer Workgroup File Strategy
- Preparing Your Developer Workgroup File
- The Developer Workgroup File is Ready
- Securing Your Database with Your Developer Workgroup File
- One Secure Object Marks a Developer s Territory
- Transferring Ownership of the Database and all its Objects
Similar products
Microsoft Access Small Business Solutions: State-of-the-Art Database Models for Sales, Marketing, Customer Management, and More Key Business Activities
Access Solutions: Tips, Tricks, and Secrets from Microsoft Access MVPs
Building Microsoftu00ae Access Applications (Bpg Other)
VBA Developer's Handbook, 2nd Edition