Access/Office Automation

Create Excel Solutions for Users in More than One Country or Region Learn which issues you should consider when using Visual Studio Tools for Office to create Excel 2003 solutions for end users in more than one country or region.

Resume Tracking with InfoPath, Excel, and SharePoint Most organizations use a combination of Microsoft Office documents and e-mail to create informal document tracking processes that require manual updating. This article shows you how to to automate this process.

New Product Introduction Process with InfoPath and SharePoint Learn to use an InfoPath form and Windows SharePoint Services to capture new product ideas, route them for review, and then assign a team to get to work.

Word 2003: Importing XML Data to Word 2003 Using Visual Studio Tools for Office Download this code sample to learn how to import XML data from a database into Word documents using Visual Studio Tools for Office 2003.

Office COM Add-Ins Use Visual Basic to build COM add-ins and then use them to extend your Outlook applications. These techniques can also be applied to developing COM Add-Ins for Access.

Excel 2003 Sample: Populating Worksheets with Multiple Related Records from Windows Forms Use this sample to to display Microsoft Windows Forms from a Microsoft Office Excel 2003 workbook, display related records, and write that information into formatted worksheets.

Use Excel 2003 to Create and Manage Windows SharePoint Services Web Sites How various aspects of Visual Studio 2005 Tools for Office, Excel, and Windows SharePoint Services work together in a hypothetical business scenario.

Outlook from the Managed World Get started with building add-ins for Outlook 2003 using the Visual Studio Tools for Office.

Office 2003 Add-in: Outlook Calendar Views With the Calendar Views Add-in, you can easily create and manage filters to display subsets of appointments in Outlook Calendar. Filtered views are based on labels and categories that you apply to appointments.

Introducing Outlook Add-in Support for Visual Studio 2005 Tools for Office Outlook add-in support simplifies interaction with the host application and provides a cleaner event framework for creating add-ins along with streamlined security.

Creating an Outlook Task Add-in Solution with Visual Studio 2005 Tools for Office Using new Outlook add-in support in Microsoft Visual Studio 2005 Tools for the Microsoft Office System to create Word 2003 task reports using WordProcessingML and XML expansion packs and a context menu for tasks in Outlook.

Architecture of the Outlook Add-in Support in Visual Studio 2005 Tools for Office Learn about new support for managed add-ins in Microsoft Office Outlook 2003, introduced with Microsoft Visual Studio 2005 Tools for the Microsoft Office

Create Your Own Symbol Sets for the Office 2003 International Character Toolbar Add-In

MS Office Interoperability This articleis an excerpt from Microsoft .NET Development for Microsoft Office, from Microsoft Press (ISBN 0-7356-2132-2, copyright Microsoft Press 2005, all rights reserved):

• Chapter 2, Part 1: Discusses managed interop assemblies for Microsoft Office XP and Microsoft Office 2003, and illustrates some basic interop projects with Microsoft Office Excel, Microsoft Office 97, Microsoft Office 2000, Microsoft Office Word, Microsoft Office Outlook, and Microsoft Office PowerPoint.
• Chapter 2, Part 2: Discusses Microsoft Visual Studio .NET Office interop wizards, explains interface/class ambiguity in Microsoft C# and Microsoft Visual Basic .NET, and explains how to release COM objects by using simple garbage collection, the ReleaseCOMObject method, and AppDomain unloading.
• Chapter 2, Part 3: Compares Visual Basic .NET and C#, and illustrates debugging interop solutions. Also includes a summary of the entire chapter.
• Download sample code

Do-It-Yourself VB Script Center Kit  This MS download containing sample scripts and documentation enabling you to create your own version of the TechNet Script Center, either as stand-alone Web pages, stand-alone .vbs files, or as a .chm Help file. The Kit also includes instructions for using these helper scripts, and the really great thing about it is that it contains an MS Access database with 2,214 sample scripts for the Windows Scripting Host!

Using the Excel XML Toolbox for Microsoft Office Excel 2003 How to use the Excel XML Toolbox to help you work with custom-defined XML schemas, XML and the Excel object model, and SpreadsheetML.

Understanding Security for Add-ins and VBA Macros in Excel 2003

Windows SharePoint Services Service Pack 1 Windows SharePoint Services Service Pack 1 provides the latest updates to Windows SharePoint Services.

Shut Down an Instance of Microsoft Word From Advisor.com When an Microsoft Access application that uses Microsoft Word crashes, it doesn't always close the instance of Word. Find out how to shut Word down from within Access.

Excel XML Toolbox for Microsoft Office Excel 2003 Provides many useful tools for working with XML in Excel.

Outlook 2003: Integration API Reference  This reference contains conceptual overviews and reference topics to guide you in developing solutions based on the Microsoft® Office Outlook® 2003 Integration APIs.

Office 2003 Tool: FabriKam – The Microsoft Office System Solutions Learning Platform A compiled help file (CHM) for use with the FabriKam sample files.

Fabrikam 2.0 complete Microsoft® Office XP Sample Solution including .NET XML Web services

Excel 2003 Sample: Replicating Formulas to SQL Server Learn how to automate a process for storing Excel 2003 formulas in a SQL Server database. This allows access from the database to the calculated spreadsheet values available only in the worksheet.

Automating the XML Data Mapping Process in Excel 2003 In the first of a three-part series, learn how to use XML maps to customize Excel as a data input and display system.

XSH: Interactively Manipulate and Analyze XML Data from DevX.com's XML Zone. Most developers use some kind of XSLT engine to pick out and process data from structured XML files. Learn how XSH, an open source command-line XML shell, lets you interactively query and manipulate this data without the coding overhead.

Create a PowerPoint Slide Presentation from Scratch Using Access Data Create a slide presentation, as well use an existing PowerPoint presentation inside an Access form.

Use Automation with Access and Outlook Demonstrates using automation to control one program from another program.

Animate Access 2003 Use the Animation ActiveX control, the Timer control, and the Office assistant to animate Access 2003.

Perform Mail-Merges Using XML Data How to use an external XML data file and the Mail Merge feature of Word 2003 to perform a mail merge programmatically from Access 2003.

Program Printer Settings in Access 2002 How to take a Word document formatted in Outline View and display it as a PowerPoint presentation slide show.

Access Workflow Designer Call-Tracking Sample Team Solution How to take advantage of the Call Tracking sample team solution. The sample accompanies the article, "Microsoft Access Workflow Designer Call-Tracking Sample Team Solution," in the MSDN Library. (January 2000)

Northwind Traders Direct Sample Application A simple e-commerce application that uses data access pages, frames, and cookies. It was created using Microsoft FrontPage 2000 and Microsoft Access 2000. (January 1999) 

Customizing List Item Forms in Windows SharePoint Services Enhance and extend interaction with lists in Microsoft Windows SharePoint Services when customizing forms used to work with list items.

Accessing FrontPage Commands Using VBA Discover how to access almost every FrontPage command from your VBA code—even commands that aren't available through the FrontPage object model.

Creating Excel Solutions for Use in Multiple Countries/Regions Using Visual Studio Tools for Office Learn which issues you should consider when using Visual Studio Tools for Office to create Excel 2003 solutions for deployment to end users in more than one country or region.

Enabling SSL Protection on MCMS Sites Learn how to set up Secure Sockets Layer (SSL) for your Microsoft Content Management Server (MCMS) 2002 site.

Customizing Office 2003 Research Services: 15 Answers to Common Questions Common issues facing developers when customizing the Office 2003 Research Services including tips about formatting data, scaling images, and encoding data.

Customizing Microsoft Office Information Bridge Framework for Microsoft CRM Learn to customize the Microsoft Office Information Bridge Framework for Microsoft Business Solutions CRM to meet the unique needs of your business organization.

Using the Excel 2003 XML Tools Add-in Version 1.1

Transforming Word Documents into the XSL-FO Format XSL-FO and WordprocessingML, when used together, create an extremely useful tool for transforming Word documents into other standard formats such as HTML or PDF.

Automating Word Tables for Data Insertion and Extraction Learn some of the best ways to automate the creation and formatting of tables in Word. 

Business Intelligence Portal Sample Application for Microsoft Office 2003 An integrated, web-based OLAP solution that enables employees in an organization to create and share OLAP/Relational/XML based views, using SharePoint Portal Server, SQL Server Reporting Services, and Office Web components.

Excel 2003 Add-in: XML Tools Add-in This add-in accompanies the MSDN article "Using the Excel 2003 XML Tools Add-in" available from the Related Resources box section of the page.

Word 2003 Sample: Automating Word Tables for Data Insertion and Extraction This download accompanies the MSDN article "Automating Word Tables for Data Insertion and Extraction" available from the Related Resouces section of the page.

Word 2003 Sample: Transforming Word Documents into the XSL-FO Format This sample accompanies the MSDN article "Transforming Word Documents into the XSL-FO Format" available from the Related Resources section of the page.

Creating XML Mappings in Excel 2003 Walk through common XML tasks in Microsoft Office Excel 2003 to learn more about the new XML functionality in Office 2003 Editions.

Integrate Data into Your Excel Spreadsheets with Office Web Services This MSDN Article discusses:

• How you can integrate data from several Web services using Excel & VBA
• The features of the Office Web Services Toolkit
• How you can manipulate your data in Excel and use it to create reports
• A sample application to get you started

Excel: Integrate Far-Flung Data into Your Spreadsheets with the Help of Web Services Make the most of the data returned from your Web services with the Office 2003 Web Services Toolkit API and take advantage of the latest capabilities to customize list views, graphs, and charts.

Handy Tips for Working with Excel 2003 Make your applications more robust and provide more options for your users when you employ and modify these tips from the Excel newsgroups.

Working with PowerPoint Presentations from Access Using Automation Learn to use automation to work with Access and PowerPoint. This gives you the ability to work from inside Access to create a slide presentation as well as use an existing PowerPoint presentation inside an Access form.

Office 2003 Sample: Working with PowerPoint 2003 Presentations from Access 2003 Using Automation Download this sample to work with PowerPoint 2003 presentations directly from Access 2003. This sample accompanies the MSDN article "Working with PowerPoint 2003 Presentations from Access 2003 Using Automation," available from Related Resources.

Creating a FrontPage Drop-Down Menu with JavaScript If you've ever tried to create a drop-down menu, you probably know it’s not always easy. This article provides the detail you need to start developing your own—as well as JavaScript for three kinds of drop-down menus.

Handy Tips for Working with Excel 2003 Make your applications more robust and provide more options for your users when you use and modify these tips from the Excel newsgroups for your own use.

Handy Tips When Using MS Word 2003 Tips and VBA code to make your MS Office applications more robust and even provide even more options to users.

Office 2003 Add-in: Microsoft Outlook SMS Add-in (MOSA) Send SMS text messages through most Global System for Mobile Communications (GSM) mobile phones connected to your PC using Microsoft Office Outlook 2003.

Information Rights Management In Office 2003

Microsoft Office Outlook 2003 Inside Out: Using VBA in Outlook Introduction to the VBA environment. Provides examples of simple ways to use VBA within Outlook 2003 to automate common tasks.

100 Microsoft Office Tricks: 100 MS Office Tricks: Part 1  100 MS Office Tricks: Part 2

Information Bridge Framework

Office 2003 Editions: Excel VBA Language Reference

Office 2003 Editions: Office Web Components VBA Language Reference

Office 2003 Editions: Outlook VBA Language Reference

Office 2000 Outlook Today information and sample files (2)

HTML Help Workshop sample files Sample cascading style sheet (CSS) files to use with HTML Help Workshop. Download HTML Help Workshop from the MSDN Online Web Workshop.

Office 2000 Outlook 98/2000 E-mail Security Update White Paper

Office 2000 Outlook Bar reference information

Office 2000 Outlook 2000 SR-1 Security and Encryption White Paper

Office 2000 Resource Kit Readme file — updated August 31, 1999 Additional information about Office 2000 and Office Resource Kit tools and documentation. The latest version includes notes about reinstalling Office with your original customized settings.

Access 2000 Runtime for Terminal Server

Office 2000 Outlook Information A sample Microsoft Outlook profile.

Office 2000 transform for Setup error messages Copy this transform (MST file) to your computer in the same folder as the Office 2000 Setup.exe and Setup.ini files.

Office 2000 Multilingual Deployment Guide

Microsoft Office Project Initiation Tool An add-in for the Microsoft Office Accelerator for Six Sigma that enables you to easily capture and rank new project ideas, approve them, and initiate the project within Microsoft Project Server 2003 SP1. The tool tracks the progress of each idea through its approval process.
Microsoft Office Information Bridge Framework 1.0 - Updates

101 Visual Basic Code Samples This download includes a master set of Visual Basic code samples demonstrating various aspects of the language in the following areas: syntax, data access, Windows Forms, Web development and Web services, XML, security, the .NET Framework, file system and file I/O, interop and migration issues, COM+, ADO.NET, and advanced topics including graphics with GDI+, remoting, serialization, MSMQ, and Windows services.

VBA Samples for Working with Excel 2003 Worksheets Macros that you can use to add additional functionality to your Excel worksheets.

Creating Charts in Excel 2003 Using Visual Basic for Applications Code Methods of creating charts though the macro recorder, using VB and automation.

Office Talk: Easy Task Reports with Outlook and WordML How to export Outlook 2003 task data to XML and then use this as a source for reports in Word 2003. Sample Files

Microsoft Office Data Assistant for PowerPoint 2003 An easy-to-use method of inserting and managing graphical data objects such as Microsoft Office Visio® drawings, Microsoft Office Excel charts, and named ranges into PowerPoint presentations.

MS Outlook 2003 Sample Custom Calendar Providers for Outlook 2003: sample files for creating custom views in MS Outlook using a Web service.

Office2003 Tool: Add a Bilingual Translation Dictionary Service to the Microsoft Office System Sample source code and helper files used in the preparation of bilingual translation dictionaries for use with the Microsoft Office System.

Excel 2002 Sample: Five Handy Charting Tips This download includes a collection of handy add-ins and techniques for use with Excel charts focused toward creating and working with Gantt charts.

Excel 2003 Sample: Create an Expense Report Template This sample demonstrates how you can reuse legacy forms by converting them to XML data maps in Excel through the use of XML schemas.

An Excellent MS Office 2003 Resource Office2003 Zone from officezealot.com

Office 2000 VBA Programmers Guide On-Line Version

Using Visual Basic and ASP with XML to Generate Excel 2003 Workbooks In this article learn different ways to use XML files and XML style sheets to create formatted Excel workbooks. You can create XML templates using either ASP or Visual Basic to create Excel workbooks.

Ms Access ADO.NET OleDb Database Connection with OleDBDataReader This tutorial explains how to create a connection to an MS Access Database using an OleDB Connection Object

Using Schemas with Word 2003 and Excel 2003 MS Access guru Mary Chipman provides an easy to follow introduction for working with the new XML functionality in the Microsoft Office System by walking through common XML tasks in Word 2003 and Excel 2003.

NSW MSDN article Microsoft Office Word 2003 XML: Memo Styles Sample, which examines some common XML-related tasks using the menus, task panes, and other parts of the user interface.

Using Visual Basic and ASP with XML to Generate MS Excel 2003 Workbooks A new article from MSDN on different ways to use XML files and XML style sheets to create formatted Excel workbooks. You can create XML templates using either ASP or Visual Basic to create Excel workbooks.

Using Automation in Access 2003 to Work with Outlook 2003

Word 2003: XML ViewerView MS Word 2003 XML files as HTML in Internet Explorer.

Editing XML Data with Microsoft Office Word 2003 and Microsoft Office Excel 2003 

Access/Office Deployment and Migration

Get the Most from the Office 2003 Primary Interop Assemblies Learn how to get and install the Office 2003 primary interop assemblies (PIAs), and how to reference and troubleshoot them.

Deploying Your MS Access Database Applications Three articles from MSDN:

• Preparing Your Access 2003 Database for Deployment, Part 1
• Preparing Your Access 2003 Database for Deployment, Part 2
• Packaging Access 2003 Solutions

Business Desktop Deployment Standard Download planning, building, and technical guidance, templates, and scripts to facilitate deployment of Microsoft® Windows® XP Professional and Office Professional Edition 2003.

Business Desktop Deployment Enterprise Download planning, building, and technical guidance, templates, and scripts to facilitate deployment of Microsoft® Windows® XP Professional and Office Professional Edition 2003 through Zero Touch deployment.

Migrating to Microsoft Microsoft Office 2003:

• Microsoft Office XP to Microsoft Office 2003 Migration Issues This document discusses the possible problem areas administrators might encounter when moving from Office XP to Office 2003.
• Webcast: Best practices to use when migrating from Office 2000 or Office XP to Office 2003
• Migrating Smart Tags from Office XP to the Office 2003 Editions
• Microsoft Office 2003 Editions Resource Kit The Office Resource Kit features a collection of tools designed specifically to support the Microsoft Office System, and includes comprehensive discussion of such topics as deployment, security, messaging, and worldwide support.

Step by step: Deploy Office 2003 with OneNote 2003 Learn step by step how to deploy Office and OneNote at the same time throughout your organisation.

The Office 2003 Resource Kit If you're a network administrator, you'll want to check out the free Office 2003 Resource Kit. It's the definitive guide to deploying, customizing, and maintaining Office throughout your organisation.

New spreadsheet reveals Office 2003 setup defaults A new spreadsheet, Office 2003 Setup defaults.xls, is now available in the Office 2003 Resource Kit. It documents the default installation settings for Office 2003 and the Office family applications FrontPage, OneNote, Project, and Visio.

Network Installation Wizard, Version 2.1 for Office 97 Download the Network Installation Wizard, Version 2.1, for use with the network installation of Microsoft Office 97 (5/24/2005).

System Policy Editor and Office 97 Policy Templates Download the System Policy Editor and Office 97 Policy Templates (5/24/2005).

Microsoft Office Live Communications Server 2003 Hotfix This download contains the hotfix for Microsoft Office Live Communications Server 2003 (5/25/2005).

• Choose and define your Office 2003 editions
• Identify the upgrade issues
• Create the installation point
• Customize Office 2003 editions
• Deploy and maintain Office 2003
• Active Directory and Group Policy
• Office 2003 Resource Kit
• Microsoft Office Access 2003 Conversion Toolkit
• Systems Management Server 2003 (Enterprise Only) Access

Whitepaper: Microsoft Office 2000 to Microsoft Office 2003 Migration

Whitepaper: Office 97 to Office 2003 Migration

Whitepaper:: Microsoft Office XP to Microsoft Office 2003 Migration

Access 2003 Conversion Toolkit Use the Toolkit to find and analyze your databases in preparation for switching to the latest version of MS Access.

Office 2003 Update: Redistributable Primary Interop Assemblies The Office 2003 Primary Interop Assemblies (PIA) redistributable is a Microsoft Windows Installer package that contains the Primary Interop Assemblies for Microsoft Office 2003 products.

Best Practices for Ensuring Application Reusability and Upgrade in Windows SharePoint Services Revisit key information in the Windows SharePoint Services SDK to understand best practices for writing code that will be reusable when you apply software updates, upgrades, or security updates to a deployment.

Desktop Deployment of Office Professional Edition 2003 This overview shows the business value Microsoft gained with the deployment of Microsoft Office Professional Edition 2003 (3/25/2005).

Introduction to the Office 2003 Primary Interop Assemblies Sample Launcher (OPSL) Learn how the OPSL provides code, samples, and a convenient launching program making it easier for developers to see how some of the most prominent methods they use can be coded.

Desktop Deployment—Office 2003 Overview of business value Microsoft gained with the deployment of Microsoft Office Professional Edition 2003.

Installing and Using the Office 2003 Primary Interop Assemblies Find out how to get, install, and use the primary interop assemblies (PIAs) available for Office 2003.

Office 2000 to Office 2003 Migration Issues Possible problem areas administrators might encounter when moving from Office 2000 to Office 2003.

Microsoft Office XP to Microsoft Office 2003 Migration Issues Possible problem areas administrators might encounter when moving from Office XP to Office 2003.

A summary of all essential service packs including download links for Access 2 through to Access 2002.

Office 97 Resource Kit as Compiled HTML Help file for all you loyal Office 97 developers and users.

Provides tools, white papers, and code samples of building research services for MS Office 2003.

An overview of developer technologies and tools for building custom solutions for MS Office 2003 Editions.

Best Practices for Ensuring Application Reusability and Upgrade in Windows SharePoint Services Revisit key information in the Windows SharePoint Services SDK to understand best practices for writing code that will be reusable when you apply software updates, upgrades, or security updates to a deployment.

Office 2003 Tool: Local Installation Source Tool
A wizard to help manage Local Installation Source (LIS) on computers running Microsoft Office 2003

Microsoft Office XP to Microsoft Office 2003 Migration Issues Office XP to Office 2003 migration issues. This paper discusses the possible problem areas administrators might encounter when moving from Office XP to Office Office 2003.

Microsoft Office 2000 to Microsoft Office 2003 Migration Issues Office 2000 to Office 2003 migration issues. This document discusses the possible problem areas administrators might encounter when moving from Office 2000 to Office Office 2003.

Office XP Document: Update Deployment White Paper Microsoft Office XP Update Deployment White Paper

Access/Office Runtime & ODE

Basics for Building Microsoft Office Access 2003 Runtime-Based Solutions

Microsoft Component Installer Software Development Kit for Windows (MCISDK)

Office Runtime

• Learn the basics for building Access 2003 Runtime-based solutions: Basics for Building Microsoft Office Access 2003 Runtime-Based Solutions
• Understand how to obtain and deploy the Access 2003 runtime: Obtain and deploy the Access 2003 runtime

Basics for Building Microsoft Office Access 2003 Runtime-Based Solutions MSDN article on how to use the MS Access 2003 Runtime with the Microsoft Access 2003 Developer Extensions so users without Microsoft Access 2003 installed can still use Access-based applications.

Office XP Service Pack 3 (SP3) for Access 2002 Runtime Office XP Service Pack 3 (SP3) for Access 2002 Runtime provides the latest updates to the Access 2002 Runtime. Contains security enhancements, and stability and performance improvements.

Access 2000 Run-Time Have you ever wondered why the Access 2000 runtime files (150mb) are massively larger than the Access 97 runtimes (12mb)? MS Knowledge Base article Q240959 explains why. But there is way of halving this bloat to 70mb by using the cut-down version of the Access 2000 runtimes

Updated Microsoft Visual Basic 6.0 and MS Office ODE Common Controls Update for the  Common Controls: mscomctl.ocx and comctl32.ocx. Each  .ocx contains the following controls:

• Image Combo Control (mscomctl.ocx  only)

• Image List Control

• LisrView Control

• ProgressBar Control

• Slider Control

• StatusBar Control

• TabStrip Control

• Toolbar Control

• Treeview Control

The mscomtcl.locx is the later and less error-prone incarnation.

Deploy Complex Access 2003 Runtime-Based Solutions
Use the Package Wizard in the Access 2003 Developer Extensions to create packaged Access solutions.   

Access Projects and SQL Server

Managing SQL Server - Using the SQL-DMO Object Model from Access

Extending Office 2003 for Enterprise Reporting and Analysis Extended Microsoft Office Excel 2003 functionality and use Web services to access discrete backend SQL Server databases.

SQL Server Express Utility SSEUtil is a tool that lets you easily interact with SQL Server:

• Connect to the main instance or user-instance of SQL Server.
• Attach, detach, and list the databases on the server.
• Upgrade database files to match the version of the server.
• Execute SQL statements via the console (similar to SQLCMD).
• Retrieve the version of SQL Server running.
• Enable and disable trace flags (for example, to trace SQL statements sent to the server by any client application)
• List the instances of SQL Server on the local machine or on remote machines.
• Checkpoint and shrink a database
• Measure the performance of executing specific queries.• Create and playback lists of SQL commands for the server to execute.
• Log all input and output.

Part 3: Replicating Excel 2003 Formulas to SQL Server In the third of a three-part series, learn how to use XML maps to automate a process for storing Excel 2003 formulas in a SQL Server database. Includes downloadable code.

Managed Data Access Inside SQL Server with ADO.NET and SQLCLR Managed code can use ADO.NET when running inside SQL Server 2005 using the new SQLCLR feature. Basic scenarios of in-process data access, SQLCLR constructs, and their interactions, are covered.

Business Intelligence Portal Sample Application for Microsoft Office 2003 This business intelligence portal sample application for Microsoft Office 2003 is an integrated, Web-based OLAP solution that enables employees in an organization to create and share OLAP/Relational/XML- based views, using Microsoft SharePoint Portal Server, SQL Server Reporting Services, and Office Web components (6 April 2005).

Download: Better SQL Server performance with Profiler and Query Analyzer The overall performance of Microsoft's SQL Server can only be as good as the queries that are sent to it. In this download, learn how to use SQL Server's SQL Profiler and Query Analyzer to experiment with alternate constructions of SQL to get better performance.

Excel 2003 Sample: Replicating Formulas to SQL Server Learn how to automate a process for storing Excel 2003 formulas in a SQL Server database. This allows access from the database to the calculated spreadsheet values available only in the worksheet

Manage SQL Server Security with Access How VBA projects provide routines to manage SQL Server security settings.

Business Intelligence Portal Sample Application for Microsoft Office 2003 An integrated, web-based OLAP solution that enables employees in an organization to create and share OLAP/Relational/XML based views, using SharePoint Portal Server, SQL Server Reporting Services, and Office Web components.

What's New and Different for the Access Developer Moving to SQL Reporting Services Review Microsoft SQL Server Reporting Services, specifically

Moving Your Access 2002 Database to SQL Server 2000 Use this features comparison in preparation for moving your MS Access 2002 database back-end to SQL Server 2000.

SQL Server Express, Encrypting Data, And More

Develop Client/Server Solutions with Access 2000 Projects How to create and work with Access project (.adp) files. The samples accompany a series of articles from the online book, "Developing Client/Server Solutions with Access 2000 Projects," in the MSDN Library. (February 2000)

MSDE 2000 Deployment Toolkit (Sample Application) Automates the process of creating an integrated package with both the application and the MSDE database.

Signing Access 2003 Projects How to digitally sign your code.

Excel 2002/2003 Add-in for SQL Server Analysis Services Access multidimensional data, perform in-depth analysis, and create flexible, interactive reports in Microsoft Excel.

Integrating Word, Excel, and InfoPath with SQL Server 2000 New article on how Excel 2003, Word 2003, and InfoPath 2003 provide a variety of ways to connect to and interact with SQL Server data.

Data Points: Data Access Strategies Using ADO.NET and SQL Data Access Strategies Using ADO.NET and SQL

.NET Rocks! - Kimberly Tripp on SQL Server 2005 USB Key demonstration of SQL Server 2005 partitioning.

Access Security

• About Protecting a Microsoft Access Database
• Access Users and Groups
• Creating Secure Data Access Pages

ADO

Getting Started with ADO - Or, Using Access Data (without Using Access)

Visit MSDN's ADO Programmer's Guide which provides an overview of how to use ADO objects to work with data from various data sources.

Using an ADO.NET DataSet as a Reporting Services Data Source How to build a data processing extension for Reporting Services using an ADO.NET DataSet as a data source.
Data Points: Handling Data Concurrency Using ADO.NET How to handle data concurrency violations in ADO.NET.

Hardcore Visual Basic: Database Developer Corner: Managing Disconnected Data in ADO and ADO.NET Demonstrates fabricated RecordSets in VB6 and DataTables in VB.NET.

Using an ADO.NET DataSet as a Reporting Services Data Source How to build a data processing extension for Reporting Services using an ADO.NET DataSet as a data source.
Data Points: Handling Data Concurrency Using ADO.NET How to handle data concurrency violations in ADO.NET.

Schemas in ADO.NET 2.0 Use the enhanced support in ADO.NET 2.0 to access metadata in your data sources.

ADOMD.NET ADOMD.NET is a .NET object model, used for building client data access applications, for accessing an XML for Analysis (XMLA) 1.1 compliant data provider, such as that provided by the XML for Analysis 1.1 SDK.

Accessing Microsoft Office Data from .NET Applications In this MSDN article see how to get Microsoft Access and Excel data out of your Office files and into your .NET applications, and how the OLE DB provider can be used to write generic code that makes working with .xls or .mdb files easier.

First Look at ADO.NET 2.0 ADO.NET 2.0 extends and enhances ADO.NET in multiple directions.

Consuming ADO.NET DataSets in the Microsoft Office System Linking MS Office solutions and ADO.NET using COM interoperability and the new XML features of Microsoft Office 2003.

Data Points: Data Access Strategies Using ADO.NET and SQL Data Access Strategies Using ADO.NET and SQL

Understanding ADO 's Default Cursor Type

Forms and Reports

Free Book Chapter On Advanced Access 2003 Reports Download this sample chapter fromMicrosoft Access 2003 Forms, Reports, and Queries, which discusses various useful methods for controlling report output. Learn about sorting and grouping, adding calculations, launching reports using command buttons and macros, and more.

Microsoft Office System Webcast: Adding Functionality to Forms with Access 2003

Small Business Webcast: Customizing Reports Using Microsoft Access 2003

Working with Controls on Forms and Reports

Smart Access: Invisible Forms Revisited: Park Your Global Values Here! How adding an invisible form to your application can make a number of difficult tasks much easier.

Smart Access: Eventful Formatting for Access Forms Dynamically changing your form's properties at runtime can often provide a better experience for your users. Access guru, Rick Dobson, shows you some secrets for dynamically changing your form's background as it gains and loses focus, keeping subforms in view, and providing colorful feedback for data.

Smart Access: Access Interfaces: Building Explorer-style Forms This article and sample application looks at the surprisingly simple process of implementing an Explorer-style form architecture using the TreeView component that's part of the Windows XP Common Control Library.

Smart Access: Invisible Forms Revisited: Park Your Global Values Here! How adding an invisible form to your application can make a number of difficult tasks much easier.

Program Pivot Tables for Access Forms

Access Interfaces: Creating Paired Listbox Controls, Part 1 How to create linked Listbox controls and base them on a single table, two tables, or even data created at runtime.
Access Interfaces: Creating Paired Listbox Controls, Part 2 Create paired listbox controls by adding two additional functions: deferring data updates and restoring initial contents.

Designing a Better GUI A very useful article on constructing better MS Access data entry forms from ssw.com.au 

Access 2003/2002/2000 Sample: Summing in reports sample database Provides example reports that demonstrate creating group sums, report sums, page sums, running sums, and how to number the rows in your MS Access reports.

Starting a Label Report with Any Label on the Sheet

How To...

How to Use Command-Line Switches in Microsoft Access

Get Started on Access VBA Error-Handling These overview articles from MSDN on implementing error-handling in Office applications are a good starting point for new developers:

• Elements of Run-Time Error Handling
• Basic Error Handling

Checking, Resolving, and Fixing Broken Library References in your MS Access Applications Access versions 97, 2000, and 2002/2003 resolve broken references differently, so you need conditional code for each run-time environment. The following Access KB articles are a good starting point for this difficult topic:

• How to resolve reference issues in an Access database
• How Access 2002 resolves VBA references
• How Access 2000 resolves VBA references
• How Access 97 resolves VBA references

This article from trigeminal.com is the best I have read on the topic: How to guarantee that references will work in your Access Applications

Smart Access: Access Answers: Hide Your Input, and it's Pretty Common How you can enhance the built-in InputBox, as well as how to programmatically call a couple of the standard Windows dialogs (the Color and Font dialogs).

Create Word 2003 Documents from Any Version of Access

The official MS Office home page http://office.microsoft.com/home/default.aspx has been revamped and has many useful links.

Write Setup Packages for Your Access Databases How to create a custom .msi setup program for your Access database and supporting files.

Program PivotTable Reports in Access 2002 How to programmatically build and manipulate PivotTable reports in Access 2002.

Program OLAP Databases from Access Using DSO How to use the DSO library to create and manipulate OLAP databases and cubes on an Analysis server.

Smart Tags: Realize the Potential of Office 2003 by Creating Smart Tags in Managed Code Learn how to build and deploy managed smart tags, and how they work with Microsoft Office Smart Tag List XML schema, advanced managed smart tags for Office 2003, and Office XP.

Installing and Using the Office 2003 Primary Interop Assemblies Find out how to get, install, and use the primary interop assemblies (PIAs) available for Office 2003.

Enhancing Office 2003 Research Services with Graphics and Fancy Fonts how to jazz up a Microsoft Office 2003 research service by displaying results using graphics and special fonts.

Learn the basics for building Access 2003 Runtime-based solutions: Basics for Building Microsoft Office Access 2003 Runtime-Based Solutions

101 Visual Basic Code Samples This download includes a master set of Visual Basic code samples demonstrating various aspects of the language in the following areas: syntax, data access, Windows Forms, Web development and Web services, XML, security, the .NET Framework, file system and file I/O, interop and migration issues, COM+, ADO.NET, and advanced topics including graphics with GDI+, remoting, serialization, MSMQ, and Windows services.

VBA Samples for Working with Excel 2003 Worksheets Macros that you can use to add additional functionality to your Excel worksheets.

Protecting Microsoft Access Command Bars And Menus From AcesssAdvisor.com Keep Microsoft Access users from closing or moving your command bars and menus with this technique.

Access 2003/2002/2000 Sample: Basing One Combo Box on Another sample database This sample database, for the Basing One Combo Box on Another column on Office Online , includes an example form that demonstrates how to limit what appears in one combo box based on the choice you make in another combo box.

Smart Access: Access Interfaces: Handling Price Ranges Discover two methods for handling the common case of multiple prices for a given product, depending on the quantity ordered.

Developer Considerations When Choosing a File Format in Access 2002
http://msdn.microsoft.com/library/en-us/dnacc2k2/html/odc_acFormat.asp

Database design - What Do Your Customers Want?

Where Should You Store Data?

Built-in Access Functions and Methods

How to Customise Menus and Menu Bars in MS Office This article uses MS Excel to demonstrate customisation of Office CommandBars.

Handling Image Storage in MS Access Databases Interesting articles with many references from ammara.com, the makers of DBPix, an Image Control for building database applications with picture handling capabilities, such as photo databases and other image management systems:

Images - Access image storage Avoiding overhead and loss when storing images in Microsoft Access.
Pictures in Access Forms & Reports Common Access OLE Object Photo & Image Problems including Access 2003.
Access Image Database Techniques Access image-handling approaches compared.

Access 2003/2002/2000 Sample: Multiple Column Reports Sample Database The Multiple Column reports sample database for Microsoft Access contains sample reports that demonstrate creating telephone book style multiple column reports.

Lost in Translation How to create an application to be deployed in different languages for different locales or different groups of users.

Managing State Transitions How to use lookup

Excel 2003 Sample: Microsoft Excel 2003 Inside Out Sample files from the book Microsoft Excel 2003 Inside Out.

Excel 2003 Sample: Microsoft Office 2003 Inside Out Sample files from the book Microsoft Office 2003 Inside Out.

Access 2003 Sample: Inside Out Sample Files Sample files from the book Access 2003 Inside Out.

Formatting Access 2002 PivotCharts with VBA

Need help with MS Access? Try these free resource, support, and forum sites:

• Allexperts.com Volunteer experts answer one-on-one Microsoft Access questions for free.
• AxSOS Submit your MS Access questions and receive responses by email. Has a searchable FAQ.
• Experts-Exchange.com: Microsoft Access Exchange information and solve problems in discussions forums.
• OpenITx: Access-L An email list and archive of all aspects of MS Access development.
• QuickTechUSA Discussion Forum Active forum discussing all aspects of MS Access.
• Tek-Tips Microsoft Access Forum Technical support forums and mutual help system for Access developers.
• Utter Access Discussion Forums Free site with discussion forums and entry level articles about using Access.

How to Customise Menus and Menu Bars in Excel Applies generally to Office 2000 and later.

Security in Office 2003 Editions How to hook into the security features in Office 2003 Editions and, more importantly, how to avoid accidentally circumventing them in your Office-based solutions.

Working with Files and Folders in Office 2003 Editions Tips on how to use the Office object model to enhance your custom solutions.

MSDN Library Archive for older content.

Tech Republic - 14 Access Articles

Office 2003 Code Focus from DevX

MSDN: Ten Tips for Microsoft Office VBA Library Development

VBA AND VB.NET Code Samples

Relationships: Your Key to Data Integrity in MS Access 2003 Sample Chapter from Alison Balter's Mastering Microsoft Office Access 2003

MS Access Resources (Microsoft Access 2000 Technical Articles) This article provides an extensive list of MS Access 2000 development resources from the MSDN, TechNet, Knowledge Base, Office Update, and other Microsoft sites.

Access Interfaces: Creating Paired Listbox Controls, Part 1 How to create linked Listbox controls and base them on a single table, two tables, or even data created at runtime.
Access Interfaces: Creating Paired Listbox Controls, Part 2 Create paired listbox controls by adding two additional functions: deferring data updates and restoring initial contents.

Signing Access 2003 Projects How to digitally sign your code.

Lost in Translation How to create an application to be deployed in different languages for different locales or different groups of users.

Managing State Transitions How to use lookup tables to handle hierarchies as well as complex state transitions.

Training Center for Office XP

Free Data Recovery Reports on Corrupt MS Access databases from:
. http://www.msaccessrepair.com/
. http://www.repair-access-database.com/

MSDN Office Developer Center
Editor's Blog