The Access developer's premier reference to building powerfully extensible database solutions.

Whether you're extending an existing database or developing a complex custom solution, get the code and instruction you need to exploit the power and performance of Access 2003. The newest edition of this acclaimed reference packs even more real-world examples and best practices for writing, testing, and debugging extensible database applications. Access expert Rick Dobson shows you the most productive ways to work with the enhancements in Access 2003, including new security features, built-in XML capabilities, and interoperability with Microsoft SQL Server. You also get rich, adaptable code samples to extend the power and reach of your database solutions.

Discover how to:

• Employ ADO to access enterprise data sources, such as files on a Web server
• Design and menage tables and queries using the ADOX object library and Jet SQL
• Create data forms and reports programmatically-and extend them 1.0 SQL Server 2000
• Present data interactively with Pivot Table and PivotChart dynamic views
• Program Microsoft Office objects to search for files and manipulate monus and toolbars
• Customize solutions by integrating Access with other Microsoft Office programs
• Learn techniques to help loch up proprietary code
• Explore the new Access Jet SandBox and macro security features
• Use Access to build and help safeguard SQL Server solutions
• Extend your solutions to the Web using flata access pages, Office Web Components, Microsoft Office FrontPage, and XML

Contents

• Introduction
• Data Access Models : Part I
• Data Access Models : Part II
• The ADOX library and tables
• Jet SQL, the ADOX library, and queries
• Forms, controls, and data
• Reports, controls, and data
• Designing and using PivotTables and PivotCharts
• Microsoft Office Objects
• Integrating Access with other Office applications
• Database security
• Using Access to build SQL Server solutions : Part I
• Using Access to build SQL Server solutions : Part II
• Using Access to build SQL Server solutions : Part III
• Access does the web
• XML and Access
• Index