Wrox Press Ltd. (
2003 Wrox Press
All rights reserved. No part of this book may be reproduced, stored in a retrieval system or transmitted in any form or by any means, without the prior written permission of the publisher, except in the case of brief quotations embodied in critical articles or reviews.
The author and publisher have made every effort in the preparation of this book to ensure the accuracy of the information, however, this book is sold without warranty, either express or implied . Neither the authors, Wrox Press nor its dealers or distributors will be held liable for any damages caused or alleged to be caused either directly or indirectly by this book.
First published February 2003
Published by Peer Information Inc.,
Arden House, 1102 Warwick Road, Acocks Green,
Birmingham, B27 6BH, UK
Printed in the United States
Wrox has endeavored to correctly render trademarks for all the companies and products mentioned in this book with the appropriate use of capitals. However, Wrox is unable to guarantee the accuracy of this information.
Humberto Lozano Ruiz
Scott E. Robertson
About the Authors
Robert Smith has been developing solutions with Access for over 10 years , in fact, ever since its original launch in November 1992. He currently works for EH3 Consulting, a software consultancy with offices in Edinburgh and Bath, where most of his time is spent designing Access or SQL Server -based solutions for a variety of companies throughout the UK and Europe.
When not working, Rob takes a keen interest in the progress (or otherwise ) of Crystal Palace Football Club, as well as indulging his other passion for collecting (and occasionally sampling) fine wines. In practice, the varying fortunes of the former normally mean that he spends a lot more time sampling than collecting.
Dave Sussman has spent the majority of his professional life as a developer, using both Unix and Microsoft-based products. After writing his first two books while in full time employment, he realized that being an author sounded more glamorous than being a programmer. The reality is somewhat different. He now spends most of his time writing books for Wrox Press, speaking at conferences, and playing with most beta products that Microsoft ships.
Ian Blackburn is director of Blackburn IT Services Ltd (http://www.bbits.co.uk) - an IT firm based in Kent, UK, offering technical training, development, and consultancy. He has long experience in many areas including Microsoft Office development, ASP and ADO, SQL Server, Site Server, Visual InterDev, Visual Studio .NET, ASP.NET, and e-commerce. He is an MCSE and has been a MCP since 1993.
John Colby is an independent consultant who has specialized in Access development since 1994, designing databases for companies in the U.S., Canada, Mexico, and Ireland. John is past president and current board member of Database Advisors Inc., (www.databaseadvisors.com), a not-for-profit organization dedicated to providing fellow Access and Visual Basic developers with a place to discuss what we do, why we do it, what works, and what doesn't. Database Advisors Inc. also allows developers to showcase their talents by sharing databases, wizards, and various code packages.
John lives in Connecticut with his family. He enjoys music, travel, and all things computers, and dreams of getting back to Europe someday soon.
Mark Horner is Senior Architect and Development Consultant with Torville Software, which specializes in decision support and web-centric knowledge systems. He has worked in a variety of roles with Australian, UK, and US corporations including: ANZ Banking Group, Aspect Computing, British Aerospace, Citibank, Hewlett Packard, and Tenix Defence Systems.
Mark holds a bachelor of business degree from Swinburne University of Technology and an MBA from Monash University, Australia. He is a member of the Internet Society (www.isoc.org) and a Dilbert devotee (www.dilbert.com).
I would like to thank the Wrox team for their determination 'to make the books that make the difference' and the engineers at Redmond for more great development tools. Special thanks to Sarah Bowers for getting me into technical reviewing and to Beckie Stones for getting me into writing.
Martin W. P. Reid is an Analyst at The Queen's University of Belfast. Martin has been working with Microsoft Access since version 1 and his main interest is working with Access Data Projects. He has contributed several articles to Smart Access, Inside SQL Server, and Inside Microsoft Access, and is a contributor to TechRepublic (www.techrepublic.com) and www.builder.com. He is also co-author of SQL: Access to SQL Server , published by Apress, and has been the technical editor on books involving technologies from VB.NET database programming to Oracle 9 i PL/SQL and Macromedia Dreamweaver MX.
Paul Turley, his wife Sherri, and their four children live in the small community of Port Orchard, Washington, on the shores of the Puget Sound. He works for Netdesk, Corp in downtown Seattle as a Developer Instructor and Project Consultant. He began his IT career in 1988, installing and supporting medical billing systems and obtained his MCSD certification in 1996. Paul began using Access version 1.0, SQL Server 4.21, and Visual Basic 3.0. Since then, he has built custom database systems for several businesses including Hewlett-Packard, Nike, Microsoft, and Boise Cascade. He has worked with Microsoft Consulting Services on large scale, multi- tier solutions employing new Microsoft technologies. As an independent trainer/consultant, he traveled for Microsoft and various training providers to teach project design and management, application development, and database design.
Paul currently maintains www.scout-master.com, a web-based service that enables Boy Scout units around the world to maintain their membership and advancement records on-line using ASP.NET and SQL Server. He has published course materials and has been a contributing author on books and articles, including Professional Access 2000 Programming and SQL Server Data Warehousing with Analysis Services from Wrox Press.
Helmut Watson started his IT career nearly twenty years ago writing games for the BBC micro. Soon after that he had to get a proper job so he moved into databases, initially using PC-Oracle v1.0. He quickly decided to change to DBMS that actually worked - Dbase, Clipper, Paradox, Informix, SQL Server, etc. After twenty years, there aren't many on the list left to try now.
Helmut specializes in database analysis and GUI design and runs a consultancy called "Nearly Everything" from his home in Essex, UK.
Known as Woof! to his friends (or anyone else who buys him a beer), he is a keen cyclist and a finalist in the 2000 British Marbles-on-Sand championships. Most people think he's a bit odd until they meet him - then they're sure!