• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Linking Remote Servers

Access 2002's Linked Table Wizard lets you use SQL Server 2000's new linked servers feature to gain access to remote instances of SQL Server, other client/server RDBMSs, and Jet databases. Linking a Jet database provides access to tables linked from Excel worksheets, text files, and other indexed-sequential access method (ISAM) databases, such as dBASE and Paradox. Alternatively, you can link via the Open Database Connectivity (ODBC) API to data sources for which you have current ODBC drivers. You also can link data sources that don't return traditional tabular data—such as Windows 2000 Active Directory, documents indexed by the Microsoft Indexing Service, and Exchange 2000 Web folders.


Linked servers require an OLE DB data provider for the data source. Depending on the data source type and location, as well as the capabilities of the OLE DB provider, the linked tables are read/write or read-only. Office Data Connector (.odc) files store linked table definitions. By default, Access 2002 stores .odc files in your My Documents\My Data Sources folder, the physical location of which depends on your operating system. The following sections describe two scenarios that use the Link Table Wizard to define the links. Your Access project must be connected to a local SQL Server instance to use the Link Table Wizard.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint