Real World Microsoft Access Database Protection and Security

Microsoft Access is the most popular desktop database in the world today and its very popularity means that its security measures can be easily compromised. Real World Microsoft Access Database Protection and Security takes a different approach than all the other Access books in the market by focusing from the start on all the issues that will help protect your database. It approaches protection and security from a task-by-task perspective and provides details that when put together will make your database more secure.

This book will help you to keep your staff from looking at your salary tables, stop your customers from looking at the design of your software that you distribute, and help you decide which security options are worth doing and which are generally a waste of your time.p>

Garry writes from a very experienced developer's point of view and he discusses in detail how to program all types of security issues including hiding tables as system tables, producing databases that password cracker software cannot easily crack, backing-up databases, menus, queries, and even user surveillance.

Real World Microsoft Access Database Protection and Security has an IT manager’s overview on all topics so that managers can assess the risk of different strategies. Where the topics are at an administrator’s level, the book provides a visual step-by-step guide to implementing and undoing the settings.

Contents

Chapter 1: The Access Protection and Security Driving Instructions
Chapter 2: Protecting Your Database with Startup Options
Chapter 3: Using Database Options and Attributes to Protect Data and Objects
Chapter 4: Providing a Solid Foundation with Good Programming Practices
Chapter 5: Backing Up and Recovering Your Databases
Chapter 6: User and Object Surveillance
Chapter 7: Protecting Your Database with Menus and Toolbars
Chapter 8: Developer Workgroup Security
Chapter 9: Security Concerns, Encryption, and Database Passwords
Chapter 10: Securing Data with Workgroup Security
Chapter 11: Object Protection and Security Measures
Chapter 12: Protecting and Securing Your Database with the Operating System
Appendix A Specific Access Security Information
Appendix B Registering the Access Workbench
Appendix C Why Migrate from Access to SQL Server?