sql

I have struggled for a long time to understand access security and always seen it as a weak point in what is an otherwise great resource. This book offers real life examples, source code and forms that you can use of the shelf. I'm now able to deliver professional results quickly. As a bonus - I got stuck with what turned out to be a very simple problem and, as suggested, emailed Gary with my problem. I had a reply by the next day - Impressed.

Somehow I find myself responsible for security of an Access database and am learning as I go. Until I found this book, workgroups were a mystery and very easily messed up.

The way this book is written is precisely what I needed, as a novice to much of this stuff. Being able to set up and maintain an Access database on one PC is a totally different animal from using SQL and a front-end on a network and making it all secure. First the author says what he's going to teach, then he outlines how he will present the information and why, and then he proceeds to the real meaty stuff. Because of this you understand which sections particularly apply to what you are doing. My copy already opens automatically to Chapter 8 where I have to admit I needed to start more than once. That is more a function of my lack of knowledge than of the way the chapter is written. The notes and tips are all gems. The instructions are clear and don't leave out any steps. There are details and screen shots all the way along that make it clear if you have made a mistake before you get too far past it. For example, page 262, step 7 my copy has a note added in pencil by me, first time through 'This didn't happen' - should have been a warning but I kept going. Had to go back later and correct things. It taught me to trust the instructions to the letter and not to proceed until what I am doing matches what is in the instructions.' I told you I was a novice! Too many computer manuals are written for the advanced expert - we're not all advanced experts! This book has been exactly what I needed.

Maybe it's because Garry hails from down under. Maybe New Zealanders and Australians think differently - whatever it is, this ex-pat Kiwi is glad to have found this book.

I have known Garry for quiet some time, and was surprised that he had a book in him! I have read many of Garry's journal articles and subscribe to his newsletter and have always found his comments and tips useful - I never thought this would amount to a book. I thought a book on Access security? And then I read it! There is no other resource available that has collated and explained everything you need to know about access database security. SO many other books spend a paragraph or two on how to manage work groups and then they and the other books casually mention that if you really want security move on to SQLServer. Well while that is all well and good some business can not afford SQlServer, and for some corporations, Access provides all of their business needs except the security part. So from a developer's point of view the pit falls and work arounds to finally secure Access Databases are presented in a well thought out and presented book. Good Work Garry!