Access 2000 Client/Server Solutions [With CDROM]

by Lars Klander

Covers the expert-level techniques for developing Access client/server applications and using Access as a front-end development system. Provides case studies from large corporations that offer... This description may be from another edition of this product.

• Format: Paperback
• Language: English
• ISBN: 1576104176
• ISBN13: 9781576104170
• Release Date: December 1999
• Publisher: Coriolis Group Books
• Length: 737 Pages
• Weight: 2.95 lbs.
• Dimensions: 2.0" x 7.4" x 9.3"

Customer Reviews

Good

Let me first start off by saying that this book is *NOT* meant for beginning Access/VB/VBA/SQL users. It is assumed that this book is geared towards intermediate Access/VB/VBA/SQL users.This book does one thing well in that it knows that DAO is not the future and that ADO is (for the time beginning). It spends plenty of time on detailing ADO for both Access and SQL Server.I like the fact that it deals with Access front-ends to SQL Server backends. It even takes a chapter from Kalen Delaney's masterful Inside SQL Server 7 book on SQL Server architecture.All in all, if you consider yourself at least on an intermediate programmer with the aforementioned technologies, this book will not gather dust on your bookshelf.All in all, a job well done.

Reference for Advanced Users Only

Users of this book need to have a thorough understanding of Access, SQL servers, and be familiar with writing VB and SQL code for it to be truly helpful. To their credit the authors have included VB procedures for use in tackling specific situations, and it's indexed well enough so you can find answers to particular questions. I liked the inclusion of the chapter on using Access as a front end for an Oracle database, since that approach is not widely discussed.My advice to readers of this book is to skip chapters 1 and 5. Chapter 1 was not well written and covers working with DAO. Chapter 5 was better written, but considering that ActiveX Data Objects (ADO) are becoming the industry standard, it seemed a bit odd that DAO received so much coverage up front. In any case, I'd treat those two chapters as appendixes, and start with chapter 2, which actually does provide a good overview of Access in the client/server environment.