O'Reilly logo

Microsoft® Office Access 2003 Inside Out by John L. Viescas

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

ODBC ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required