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.
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
Published by Thriftbooks.com User , 24 years ago
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.
ThriftBooks sells millions of used books at the lowest everyday prices. We personally assess every book's quality and offer rare, out-of-print treasures. We deliver the joy of reading in recyclable packaging with free standard shipping on US orders over $15. ThriftBooks.com. Read more. Spend less.