Access 2000 Developer's Handbook^TM, Volume 2: Enterprise Edition

by Paul Litwin; Ken Getz; Mike Gilbert

• ISBN13: 9780782123722
• ISBN10: 0782123724
• Edition: 2nd
• Format: Paperback
• Copyright: 1999-12-01
• Publisher: Sybex

Summary

Expert Instruction You Need to Build and Deploy Access Applications across the Enterprise The latest from internationally recognized Access authorities Litwin, Getz, and Gilbert, the Access 2000 Developer's Handbook: Enterprise Edition offers complete coverage of every aspect of building Access applications suitable for the enterprise, including the advanced topics you've got to master to take your work-and your career-to the next level. Inside, you'll profit from scores of practical examples, carefully devised by the authors to illustrate effective, elegant solutions to real-world challenges. Coverage includes: * Develop ADP files that store data using MSDE or SQL Server * Manage concurrency using stored procedures * Synchronize SQL Server databases with Jet replicas * Create data access pages for editing and viewing Jet, MSDE, and SQL Server data * Validate data, link pages, and create dynamic HTML effects using scripting code in data access pages * Pass parameters to and from stored procedures using ADO * Manage multiple developers with source code control

Table of Contents

Introduction	xxxv
What's New in Access 2000	1	(14)
Developing Multi-User Jet Applications	15	(78)
Designing Client-Server Applications	93	(62)
Creating SQL Server Databases	155	(54)
Creating Stored Procedures and Triggers	209	(42)
Using ActiveX Data Objects with Server Data	251	(68)
Developing ADP Applications	319	(26)
Securing Your Application	345	(104)
Mastering Replication	449	(96)
Creating Data Access Pages	545	(94)
Scripting Data Access Pages	639	(50)
Using the Office Web Components	689	(84)
Using Access as a Web Client	773	(28)
Publishing Access Data on the Web	801	(84)
Using Source Code Control	885	(44)
Setup and Deployment	929	(66)
Appendix A: The Reddick VBA Naming Conventions, Version 6	995	(26)
Appendix B: VBA versus VBScript	1021	(3)
Index	1024