Access 2002 Enterprise Developer's Handbook(tm) [Illustrated] [Paperback]

Paul Litwin (Author), Ken Getz (Author), Mike Gunderloy (Author)

Book Description

ISBN-10: 0782140106 | ISBN-13: 978-0782140101 | Publication Date: November 19, 2001

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

Editorial Reviews

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.

Product Details

• Paperback: 960 pages
• Publisher: Sybex (November 19, 2001)
• Language: English
• ISBN-10: 0782140106
• ISBN-13: 978-0782140101
• Product Dimensions: 8.9 x 7.5 x 2.1 inches
• Shipping Weight: 3.6 pounds
• Average Customer Review: 4.8 out of 5 stars  See all reviews (6 customer reviews)
• Amazon Best Sellers Rank: #602,410 in Books (See Top 100 in Books)

Customer Reviews

Most Helpful Customer Reviews

3 of 3 people found the following review helpful:

5.0 out of 5 stars Excellent Self Study Guide, October 12, 2004

By 

LPB "Access Developer" (Oz) - See all my reviews

This review is from: Access 2002 Enterprise Developer's Handbook(tm) (Paperback)

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.

2 of 2 people found the following review helpful:

5.0 out of 5 stars Outstanding handbook!, August 14, 2009

By 

Carlos O. Arellano Mendez "Carlos Oscar" (México, D.F. Mexico) - See all my reviews
(REAL NAME)   

This review is from: Access 2002 Enterprise Developer's Handbook(tm) (Paperback)

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

2 of 2 people found the following review helpful:

5.0 out of 5 stars Access Locking Issues in Multi-User Network Environment, November 19, 2008

By 

J. Whisenhunt "whizterdev" (Dallas, TX) - See all my reviews
(REAL NAME)   

This review is from: Access 2002 Enterprise Developer's Handbook(tm) (Paperback)

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.