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

Chapter 25. Connecting to Client/Server ... > Adding and Removing SQL Server Data ...

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:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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