• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part 8: Appendix > Managing ODBC Connections

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.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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