Defining an ODBC Data Source

If you plan to link to ODBC tables, you must load the appropriate ODBC drivers. These drivers come with Access and are installed with the product. You also need to load drivers for the specific back-end database servers to which you want to connect. These drivers usually are purchased from the back-end database vendor and often come with a per-seat charge. This means that you must purchase a client license for each user who will connect to the remote data.

An ODBC data source is a user-defined name that points to a remote source of data. It contains all the properties of the data source that are necessary to communicate with data stored on a database server.

Before you can access a remote table from Access, you must ...

Get Alison Balter's Mastering Access 2002 Enterprise Development now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.