Real World Microsoft Access Database Protection and Security [Paperback]

Garry Robinson (Author)

Book Description

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

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. "Securing Your Microsoft Access Database" takes a different approach to all the other Access books in the market in that it focuses from the start on all the issues that will help protect your database. The book approaches protection and security from a task-by-task perspective and provides detail on all the little things that when put together will make your database more secure. This will achieve things like keep your staff from looking at your salary tables, stopping your customers from looking at the design of your software that you distribute and helping you decide which security options are worth doing and which generally a waste of your time. The book 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. Finally, as Garry is very experienced in writing for developers, the book goes into the detail of programming all types of security issues such as hiding tables as system tables, producing databases that password cracker software cannot crack (easily), backing up databases, menus, queries and even user surveillance.

Editorial Reviews

About the Author

Garry Robinson established a successful software consultancy business called GR-FX Pty Limited that has been in business for eight years. During that time, Robinson has been involved in developing and supporting over 100 Access applications for more than 30 organizations. Robinson’s clients include mining; insurance or transport businesses and quite a number of his jobs are assisting other Access programmers working for their own clients. Robinson is a contributing editor to Pinnacle Publishing’s Smart Access magazine and is an editor of the popular programming web site vb123.com. Robinson develops and sells shareware software for data mining, Access application libraries and a programmer’s knowledge base. When Robinson is not sitting at the keyboard, he can be found playing golf or swimming with the sharks at the beaches of 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: #1,059,482 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!!!