O'Reilly logo

Special Edition Using Access 97, Second Edition by Roger Jennings

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

Adding and Removing SQL Server Data Sources

An ODBC data source for a client/server RDBMS is a definition of a database—including the name of the server on which the RDBMS and database is located, the name of the ODBC driver required to connect to the database, and, optionally, the name of the database. You need at least one SQL Server data source to enable Access to attach, export, or import SQL Server tables. You can use Control Panel's ODBC Administrator tool or Access's built-in ODBC data source feature to create SQL Server data sources.

Following are the three different types of ODBC data sources supported by Access 97:

  • User data sources are specific to each user of the workstation. The definitions of these data sources are stored in the ...

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