Access 2002 Enterprise Developer's Handbook^TM

by Paul Litwin; Ken Getz; Mike Gunderloy

• ISBN13: 9780782140101
• ISBN10: 0782140106
• Edition: CD
• Format: Paperback
• Copyright: 2002-01-01
• Publisher: Sybex

Summary

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

Table of Contents

Introduction	xxix
What's New in Access 2002	1	(10)
Developing Multiuser Jet Applications	11	(64)
Designing Client-Server Applications	75	(52)
Creating SQL Server Databases	127	(48)
Creating Stored Procedures, Functions, and Triggers	175	(38)
Using ActiveX Data Objects with Server Data	213	(58)
Developing ADP Applications	271	(40)
Securing Your Application	311	(86)
Mastering Replication	397	(74)
Creating Data Access Pages	471	(84)
Scripting Data Access Pages	555	(34)
Using the Office Web Components	589	(62)
Using Access as a Web Client	651	(24)
Publishing Access Data on the Web	675	(78)
Integrating Access with XML	753	(36)
Using Source Code Control	789	(36)
Setup and Deployment	825	(54)
Appendix A: The Reddick VBA Naming Conventions, Version 7	879	(22)
Appendix B: VBA versus VBScript	901	(3)
Index	904