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 ...