This book starts where the documentation and the introductory and mid-level books leave off, covering topics that, until now, have not been addressed by books for Access developers: Access SQL, OLE, DDE, DLLs, advanced interface design, and a geat deal more. Covers version 2 of Access and the Access Developer Kit (ADK), with explanations or differences from version 1.1.
The enclosed CD contains the book's sample databases and associated files; their reusable forms and routines can be incorporated into your own work. You'll also find utilities, white papers, access to Wizard Code, Help file aids, Certification demos, and useful free- and share-ware.
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
This how-to book of custom applications shows how organizations can use Access 97 to develop effective information systems in less time, for less money. This is the one-volume reference that shows users how to automate tasks, do application programming, and integrate an Intranet or the Internet. The CD includes source files and developer tools.
Expert Instruction. Advanced Coverage. An Unbeatable Price. This two-volume set gives you the opportunity to buy the two most advanced guides to Access development at a significantly reduced price. Inside, you'll find unparalleled instruction from three internationally recognized Access experts, organized to reflect the very different requirements and techniques associated with desktop and enterprise Access development. Filled with scores of practical examples illustrating effective, elegant solutions to real-world challenges, these books will foster the skills you need to take your work-and your career-to the next level. Access 2000 Developer's Handbook, Volume 1: Desktop Edition Design, Build, and Refine Access Databases to Meet the Special Needs of Individuals and Small Workgroups Design Forms and Reports That Meet Users' Exact Needs Use Access as an Automation Client or Automation Server Take Advantage of Shared Microsoft Office Programmability Access 2000 Developer's Handbook, Volume 2: Enterprise Edition Build and Deploy Scalable Enterprise-wide Applications Develop Multi-User File-Server Applications Create Web Pages that Connect to Access and SQL Server/MSDE Data Manage Concurrency using Stored Procedures
Expert Instruction. Advanced Coverage. An Unbeatable Price. This two-volume set provides you with the two most advanced guides to Access development at a significantly reduced price. Inside, you'll find unparalleled instruction from three internationally recognized Access experts, covering the full range of Access desktop and enterprise applications. Filled with scores of practical examples illustrating effective, elegant solutions to real-world challenges, these books provide the skills you need to be a professional Access developer. Access 2002 Desktop Developer's Handbook Design and Build Access Databases for Single Users and Small Workgroups Design Forms and Reports That Meet Users' Exact Needs Take Full Advantage of the Latest Access Functionality, Including New PivotTable and Pivot Chart Views and New Programmability Features Access 2002 Enterprise Developer's Handbook Publish Data on the Web with Data Access Pages Take Advantage of Improved SQL Server Integration and XML Support Tackle the Toughest Replication and Security Challenges Put the New Office Web Components to Work in Your Access Applications
This hands-on guide provides much-needed information and guidance for the Access power user or developer wanting to exploit the power of SQL Server. It provides readers with the practical knowledge they need to harness the enterprise-level power and scalability SQL Server offers, while using the Access tools with which they are more familiar.
