Product Description

-- This updated edition of the Sybex best-selling book focuses on developing Access applications that take full advantage of the enterprise.
-- With greatly expanded coverage of client/server and Internet development, users learn how to create SQL Server stored procedures, program Access Data Pages, and deploy applications using COM+.
-- Written by acknowledged Access experts, this book is the most comprehensive solution--with the most usable code--of any book on the market.

Product Details

• Amazon Sales Rank: #669302 in Books
• Published on: 2001-11-19
• Format: Illustrated
• Original language: English
• Number of items: 1
• Binding: Paperback
• 960 pages

From the Back Cover
Design, Build, and Refine Access Applications That Meet True Enterprise Needs The latest from internationally recognized Access authorities Litwin, Getz, and Gunderloy, Access 2002 Enterprise Developer's Handbook offers complete coverage of every aspect of building client-server Access applications for large-scale enterprises. Inside, you'll find scores of practical examples, carefully devised by the authors to illustrate effective, elegant solutions to real-world challenges.

Coverage Includes:

* Developing Access projects that store data using SQL Server
* Managing concurrency using stored procedures
* Creating data access pages that allow the editing and viewing of Access and SQL Server data in a browser
* Using data access pages to validate data, link pages, and create dynamic HTML effects
* Retrieving and editing server data directly with ADO
* Managing multiple developers with source code control
* Creating Web pages that connect to Access and SQL Server data
* Controlling all aspects of replication
* Securing your Access databases and projects
* Distributing your Access applications
* Importing and exporting XML files
* Creating and managing SQL Server objects

About the Author
Paul Litwin is the owner of Litwin Consulting and a founding partner of Deep Training, where he focuses on training, mentoring, and writing about Access, ASP.NET, and Visual Studio .NET. He is the editor-in-chief of aspnetPRO, a magazine for ASP.NET developers. Ken Getz is a senior consultant with MCW Technologies, where he focuses on development, training, and writing about Microsoft technologies, including Visual Studio .NET and Microsoft Office. He speaks regularly at industry conferences. Mike Gunderloy, an independent consultant and developer in eastern Washington, is coauthor of Mastering SQL Server 2000 and SQL Server Developer's Guide to OLAP with Analysis Services, and author of Visual Basic Developer's Guide to ADO, all from Sybex. Paul, Ken, and Mike together wrote this book's companion volume, Access 2002 Desktop Developer's Handbook.

Customer Reviews

Excellent Self Study Guide
If you develop databases for 10+ demanding users and your Access MBE databases slow down under load, this text is excellent to get you started in "Access Projects" and Client-Server design.

It has one chapter on building better MDEs and around 6 solid chapters on Access Projects, including connection to SQL Server & any ODBC Server.

I love this book as in one day I grasped most of the Client-Server content and now I'm preparing to convert my MBE to a ADP.

It also covers Internet issues such as ASP and XML and has a bit on .Net.

Outstanding handbook!
This is, by far, the most complete and outstanding Access 2002 handbook I ever read. I have not been able to find an Access 2007 handbook as good as this one was for the Access 2002 (and Access 2003 to be honest, albeit the book was not written for Access 2003. Changes were so few from 2002 to 2003 that the book stands perfectly for Access 2003). Yet, it is still useful for Access 2007 even though many changes happened from 2002 to 2007, so complete this guide is.

If you want to learn to build Access databeses, even in Access 2007, purchase this book. Is a very complete guide. I fully recomend it.

Carlos Arellano

Access Locking Issues in Multi-User Network Environment
This book is priceless! The information in chapter 2 on locking enabled me to set up and test a very troubling locking issue on a network jet Access 2003 application. It is still very relevant for Access 2003 and 2007 and will enable you to address locking issues that other authors only gloss over. It provides actual working code and identifies all the possible locking error messages you might encounter and shows you how to handle them. It also provides an example of a form that uses the timer object to handle errors and prevent locking due to a user sitting on a locked record. Again, absolutely priceless. I have spent many hours on the web, an no one has answered my questions like this book.