Managing ODBC Connections
When you need to connect to your Microsoft Access database tables (in an .mdb or .mde file) from any Office application or on a Web server, you must first define an Open Database Connectivity (ODBC) Data Source Name (DSN) on the system from which you want to make the connection. You don’t need to define a connection to your database for links from another Access database—Access uses its own internal drivers to make the connection.
If you want to use Microsoft Access to connect to SQL databases that support the ODBC standard, you must install both the ODBC driver for that database and define a connection in the Microsoft ODBC Data Source Administrator. The ODBC driver for Microsoft SQL Server is included with Access.