Real World Microsoft Access Database Protection and Security

by Garry Robinson

Overview

Author Garry Robinson approaches this book differently than other Access books on the market: he keeps the focus on issues that will help protect your database. Written from an experienced developers point of view, he discusses protection and security task-by-task. This book is even recommended among Microsoft TechNet Security Topics: Threats and Countermeasures.

Youll learn to hide tables as system tables, produce databases that are difficult to crack, and back up databases. You will learn how to keep staff from viewing salary tables, prevent customers from peeking at your distributed software design, and become a better judge of worthwhile security options (versus time-consuming choices).

Product Details

ISBN-13:	9781590591260
Publisher:	Apress
Publication date:	11/11/2003
Series:	Real World
Edition description:	First Edition
Pages:	494
Product dimensions:	7.01(w) x 9.25(h) x 0.04(d)

About the Author

Garry Robinson established a successful software consultancy business called GR-FX Pty Limited that has been in business for more than eight years. During that time, he has helped to develop and supported over 100 Access applications for over 30 organizations. His clients include mining, insurance, and transport businesses. He has assisted quite a number of Access programmers working for their clients. Garry is a contributing editor to Pinnacle Publishing's Smart Access magazine and is an editor of the popular programming website http://vb123.com. He develops and sells shareware software for data mining and Access application libraries, and a programmer's knowledge base. When Garry's not sitting at the keyboard, he can be found playing golf or swimming with the sharks in Sydney, Australia.

Table of Contents

1 The Access Protection and Security Driving Instructions.- 2 Protecting Your Database with Startup Options.- 3 Using Database Options and Attributes to Protect Data and Objects.- 4 Providing a Solid Foundation with Good Programming Practices.- 5 Backing Up and Recovering Your Databases.- 6 User and Object Surveillance.- 7 Protecting Your Database with Menus and Toolbars.- 8 Developer Workgroup Security.- 9 Security Concerns, Encryption, and Database Passwords.- 10 Securing Data with Workgroup Security.- 11 Object Protection and Security Measures.- 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?.- What Is Migrating?.- Access versus SQL Server.- Reasons to Migrate.- Reasons Not to Migrate.- Migration Considerations.