Real World Microsoft Access Database Protection and Security

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.

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.