Real World Microsoft Access Database Protection and Security [Paperback]

Garry Robinson (Author)

Book Description

Publication Date: October 17, 2003 | ISBN-10: 1590591267 | ISBN-13: 978-1590591260 | Edition: 1

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

Editorial Reviews

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.

Product Details

• Paperback: 504 pages
• Publisher: Apress; 1 edition (October 17, 2003)
• Language: English
• ISBN-10: 1590591267
• ISBN-13: 978-1590591260
• Product Dimensions: 9.2 x 7.4 x 1.2 inches
• Shipping Weight: 1.6 pounds (View shipping rates and policies)
• Average Customer Review: 4.9 out of 5 stars  See all reviews (18 customer reviews)
• Amazon Best Sellers Rank: #304,993 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

8 of 8 people found the following review helpful:

5.0 out of 5 stars Access Security Book that delivers on its promises, November 20, 2003

By 

Steven White (Budgewoi, NSW Australia) - See all my reviews

This review is from: Real World Microsoft Access Database Protection and Security (Paperback)

This book is exactly what it proports to be. It covers all the Access versions being used in the development world - 97 to 2003. It does not spend half to 2/3 of the book on basic Access tables, querries, reports or vb code that developers already know, but from the first page to the last covers security and protection.

It uses real world examples and code to demonstrate how developers who are proud of their work can protect and secure their Access database so it operates as designed and your intellectual property is not avialable for all to see and use.

Well written from a developer who is obviously using these techniques in his own business every day, the code and screen dumps are easy to follow and can be migrated straight to your current work.

If you are a Access developer selling your work or having others use your work, this book is a must have. It will save time and money in the future by not having to maintain database that have been deliberately or inadvertantly changed. It is an area usually left to last in the development cycle then dropped at the end as too difficult with no return on your investment. This book shows with planning and little effort how easy it is to secure Access databases.

A must have for any Access developer or power user.

7 of 7 people found the following review helpful:

5.0 out of 5 stars Excellent book - well worth the money, December 30, 2004

By 

Robert Williams (Bay Area, CA) - See all my reviews

This review is from: Real World Microsoft Access Database Protection and Security (Paperback)

Garry Robinson's book is well written and clear. He covers the security issues thoroughly. As one reads the book, it becomes clear that Microsoft has not and apparantly has no plans to beef up security for Access. It is plagued with holes. But the book provides methods for plugging these holes. Purchasers of the book can download an accompanying database with forms that assist developers with implementing security. These forms have saved me countless hours in programming. These savings alone pay for the cost of the book many times over.

I spent quite a bit of time researching Access security through the Microsoft website and this was a complete waste of time. There are holes in the security that MS doesn't even mention (what a surprise).

This book is well worth the money for anyone who is serious about securing their proprietary efforts.

6 of 6 people found the following review helpful:

5.0 out of 5 stars Excellent book, April 25, 2005

By 

T. Bock (Virginia, USA) - See all my reviews
(REAL NAME)   

Amazon Verified Purchase

This review is from: Real World Microsoft Access Database Protection and Security (Paperback)

I recently purchased Garry's book. It provided me security solutions that I never read in any other Access book before.

Every subject is described in great detail and the downloadable sample forms and functions make it easy to quickly create a secure database.

When I got stuck on an issue, I emailed Garry and asked his team for some advice. I wasn't sure if anyone on his team would even respond. However, Garry himself answered the question within less than 1 hour and provided me the answer to the problem.

Now -- in my opionion -- that absolutely awesome!!!