Real World Microsoft Access Database Protection and Security

Garry Robinson, Apress

ISBN:1590591267, Edition: 1, 2003-10-17

Price: $59.99

Table of Contents

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 Integrating Menus into Your Forms and Reports
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
Maintaining Object Ownership and Change of Ownership
Setting Database Permissions
Further Reading
Reflecting on this Chapter
What's Next?

Chapter 9 - Security Concerns, Encryption, and Database Passwords
What is it that We Should be Concerned About?
Are Password Retrieval Programs all Bad?
Importing Objects From Other Databases
Database Encryption
Workgroup Security Files
Database Passwords
VBA Project Passwords
Further Reading
So What are the Best Access Security Strategies?
Reflecting on this Chapter
What's Next?

Chapter 10 - Securing Data with Workgroup Security
What do I Need to Know About Securing My Data?
Trusting Your Workgroup File to Other Users
Trusting Your Users by Adopting the Same Workgroup File
Opening Databases with Shortcut Files
Time for Reflection
Security Wizards
Securing Data with PID Authentication
Protecting Data Outside the Company Network
Server-Based Databases
Further Reading
Reflecting on this Chapter
What's Next?

Chapter 11 - Object Protection and Security Measures
Have I Done Enough to Protect the Objects in My Database?
A Workgroup Security Refresher
Protecting Linked Tables' Paths with Remote Queries
Protecting Your Query Design
Hiding Your Query (Design) in Forms and VBA Code
Protecting Forms by using VBA Code
Protecting Reports by using VBA Code
Protecting Macros by using VBA Code
Protecting VBA Code by using a Password
Using Data Access Pages with Workgroup Security
Access Data Projects
The MDE Database Format Revisited
Further Reading
Reflecting on this Chapter
What's Next?

Chapter 12 - Protecting and Securing Your Database with the Operating System
Why is Operating System Security Important for My Database?
Overview of Applicable Operating System Security
Proof-of-Concept Operating System Security
The Access Protected Folder Strategy
The All-Important NTFS Format
Protecting Against Unattended Computers
Issues of Relevance in Windows XP
Checklist of Other Security-Related Issues
Further Reading
Reflecting on this Chapter
Is that the End of the Journey?

Appendix A - Specific Access Security Information

Appendix B - Registering the Access Workbench

Appendix C - Why Migrate From Access to SQL Server?

Index

List of Figures

List of Tables

List of Sidebars