Real World Microsoft Access Database Protection and Security

1. Front Matter

   Pages i-xvii

   PDF

2. The Access Protection and Security Driving Instructions

   • Garry Robinson

   Pages 1-22

3. Protecting Your Database with Startup Options

   • Garry Robinson

   Pages 23-48

4. Using Database Options and Attributes to Protect Data and Objects

   • Garry Robinson

   Pages 49-80

5. Providing a Solid Foundation with Good Programming Practices

   • Garry Robinson

   Pages 81-107

6. Backing Up and Recovering Your Databases

   • Garry Robinson

   Pages 109-159

7. User and Object Surveillance

   • Garry Robinson

   Pages 161-196

8. Protecting Your Database with Menus and Toolbars

   • Garry Robinson

   Pages 197-232

9. Developer Workgroup Security

   • Garry Robinson

   Pages 233-286

10. Security Concerns, Encryption, and Database Passwords

    • Garry Robinson

    Pages 287-306

11. Securing Data with Workgroup Security

    • Garry Robinson

    Pages 307-362

12. Object Protection and Security Measures

    • Garry Robinson

    Pages 363-401

13. Protecting and Securing Your Database with the Operating System

    • Garry Robinson

    Pages 403-451

14. Back Matter

    Pages 453-494

    PDF

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).

• Microsoft Access
• SQL
• Visual Basic
• databases
• design
• encryption
• operating system
• programming
• software

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.

Policies and ethics