BackCover

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 o 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 manage tables and queries using the ADOX object library and Jet SQL
• Create data forms and reports programmatically ”and extend them to SQL Server 2000
• Present data interactively with PivotTable and PivotChart dynamic views
• Program Microsoft Office objects to search for files and manipulate menus and toolbars
• Customize solutions by integrating Access with other Microsoft Office programs
• Learn techniques to help lock 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 data access pages, Office Web Components, Microsoft Office FrontPage, and XML

About the Author

Rick Dobson, Ph.D., is a highly regarded author and trainer specializing in Microsoft Access, SQL Server, Visual Basic .NET, and Web technologies. Rick is a Microsoft Certified Professional (MCP) who writes for leading computer publications such as SQL Server Professional, MSDN, Smart Access, and Hardcore Visual Basic . He s also the author of Programming Microsoft SQL Server 2000 with Microsoft Visual Basic .NET and Programming Microsoft Visual Basic .NET for Microsoft Access Databases , both from Microsoft Press.