Microsoft® Access® 2010 VBA Programming Inside Out

Chapter 12. Linking Access Tables

• Linking Access to Access

• Linking to Excel and Text Files

• Linking to SQL Server

• Linking to SQL Azure

• Linking to SharePoint Lists

• Linking Access Web Databases

Microsoft Access 2010 has extensive features for connecting an Access database to different sources of data; this means that you can exploit the productivity with which applications can be constructed by using the product even when the data is not being held inside Access.

In this chapter, you will see how to connect an Access database to different sources of data and how to use Microsoft VBA to relink the database when you need to use an alternative data source. The most compelling reason to automatically relink a database is to undertake development work in a system ...