Real World Microsoft Access Database Protection and Security


GARRY ROBINSON

Copyright 2004 by Garry Robinson

All rights reserved. No part of this work may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying, recording, or by any information storage or retrieval system, without the prior written permission of the copyright owner and the publisher.

ISBN (pbk): 1-59059-126-7

Printed and bound in the United States of America 12345678910

Appendix C reprinted with permission from From Access to SQL Server , ISBN: 1-893115-24-0, published by Apress. Copyright 2000 by Russell Sinclair.

Trademarked names may appear in this book. Rather than use a trademark symbol with every occurrence of a trademarked name , we use the names only in an editorial fashion and to the benefit of the trademark owner, with no intention of infringement of the trademark.

Technical Reviewer: Frank Rice

Editorial Board: Dan Appleman, Craig Berry, Gary Cornell, Tony Davis, Steven Rycroft, Julian Skinner, Martin Streicher, Jim Sumser, Karen Watterson, Gavin Wray, John Zukowski

Assistant Publisher: Grace Wong

Project Manager: Sofia Marchant

Development Editor: Tracy Brown Collins

Copy Editor: Kristen Imler

Production Manager: Kari Brooks

Production Editor: Janet Vail

Proofreader: Linda Seifert

Compositor: Susan Glinert Stevens

Indexer: Kevin Broccoli, Broccoli Information Services

Cover Designer: Kurt Krames

Manufacturing Manager: Tom Debolski

Distributed to the book trade in the United States by Springer-Verlag New York, Inc., 175 Fifth Avenue, New York, NY 10010 and outside the United States by Springer-Verlag GmbH & Co. KG, Tiergartenstr. 17, 69112 Heidelberg, Germany.

In the United States: phone 1-800-SPRINGER, email < orders@springer-ny.com >, or visit http://www.springer-ny.com . Outside the United States: fax +49 6221 345229, email < orders@springer.de >, or visit http://www.springer.de .

For information on translations, please contact Apress directly at 2560 Ninth Street, Suite 219, Berkeley, CA 94710. Phone 510-549-5930, fax 510-549-5939, email < info @apress.com >, or visit http://www.apress.com .

The information in this book is distributed on an "as is" basis, without warranty. Although every precaution has been taken in the preparation of this work, neither the author(s) nor Apress shall have any liability to any person or entity with respect to any loss or damage caused or alleged to be caused directly or indirectly by the information contained in this work.

The source code for this book is available to readers at ht tp://www.apress.com in the Downloads section.

To my father, Keith, I hope that I will be as inspirational to my sons, Sean and James, as you have been to me.

About the Author

Garry Robinson got started in software development two decades ago, after completing a Masters Degree in Three-Dimensional Mapping. From there, he ran a small team of programmers that developed customized software for a mining company by using programming tools such as Fortran, Informix, and Microsoft Access. For the past eight years , he's headed his own software consultancy business, GR-FX Pty Limited, and has been involved in developing and supporting more than 100 Access applications for more than 30 organizations. Garry's clients include mining, insurance, and transport businesses, and quite a number of his jobs are assisting other Access programmers who are working for their own clients . Garry is a contributing editor to Pinnacle Publishing's monthly Smart Access newsletter and is an editor of the popular programming Web site vb123.com . He develops and sells Access database shareware software for database administration, graphical data mining, and toolkits for developers. When Garry isn't sitting at the keyboard, he can be found playing golf or swimming with the sharks at the beaches of Sydney, Australia.

About the Technical Reviewer

Frank Rice is a programmer/writer for the Office Developer Center at Microsoft. Before that, he was support engineer and application developer specializing in Microsoft Access. He enjoys working with and writing about databases, especially those in Access.

About the Foreword Author

Peter Vogel (MBA, MCSD) is a principal in PH&V Information Services. PH&V provides consulting services in client/server and intranet development. PH&V clients include Volvo, Christie Digital, the Canadian Imperial Bank of Commerce, and Microsoft. Peter's white papers appeared in the Visual Studio.NET and Microsoft Office 2003 release package. He also did extensive work on XML in Office 2003.

Peter is the editor of the Smart Access newsletter from Pinnacle Publishing ( www.pinpub.com ) and wrote The Visual Basic Object and Component Handbook (Prentice Hall), which has been called "The definitive guide to 'thinking with objects.'" Peter was the founding editor of the XML Developer newsletter, now Hardcore Web Services Developer . In addition to teaching for Learning Tree International, Peter wrote their ASP.NET and technical writing courses. His articles have appeared in every major magazine devoted to VB-based development and can be found in the Microsoft Developer Network libraries. Peter lives in Goderich, Ontario, Canada, but presents at conferences all over the world.

Acknowledgments

Over the last nine months, I have learned that a technical book like this one comes about not because of one supposedly smart developer typing words into a notepad computer on Bondi Beach , but because of the teamwork and structure provided by a professional publishing company like Apress. So thanks to those at Apress who were involved in my book, including Karen Watterson and Gary Cornell, who both said I could do it; Sofia Marchant; Tracy Brown Collins; Julian Skinner; Janet Vail; and finally to Kristen Imler, whose writing skills were the icing on the cake. I hope to meet you all in person one day.

My special thanks go to Frank Rice, the technical editor for the book, who had to wade through all my first drafts and was successful in steering the ship back on course on many occasions. To Peter Vogel, who kindly wrote the foreword, I must thank you for plucking me from obscurity in 1998 to write for the Smart Access magazine and for your guidance on good technical writing. To Russell Sinclair, thank you for allowing the readers to benefit from your knowledge on Access to SQL Server migration, which I have included in an appendix to this book.

Thanks to Bob Weiss from Password Crackers, Inc. and Dmitry Konevnik from Passware for their insights into what the smart people actually do know about Microsoft Access security.

Back home in Australia, I would like to thank Scott McManus and Doug Thatcher, whose counsel is always welcome; my clients, whose projects have helped fine-tune the real world samples in this book; and the guys at the Art Lounge in Coogee, whose wonderful coffee kept me going on many occasions. I need especially to single out John Reidy, whose system administration skills led me quickly to some useful operating system security solutions.

Finally, to my lovely wife, Fran, who endured my obsessive drive to grind out the book (and sneak off to golf) while bringing James, our latest software project, into the world just a few weeks before the book was finished. Thanks also go to my family, Mandy, Keith, and Margaret, and Fran's family, who helped out Team Robinson during this busy year.




Real World Microsoft Access Database Protection and Security
Real World Microsoft Access Database Protection and Security
ISBN: 1590591267
EAN: 2147483647
Year: 2003
Pages: 176

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net