Linking To External Data Sources In An Access Project

The Link Table Wizard is a new feature of Access 2002. If your Access project is connected to a Microsoft SQL Server version 7.0 or later database, or to a SQL Server 2000 Desktop Engine running on your local computer, you can easily link to various OLE DB data sources. By using the Link Table Wizard, you can define either a linked server or a Transact SQL function, both of which manage the link to the external data source and create the OLE DB connection string.