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

Chapter 20. Client/Server Techniques > Defining an ODBC Data Source

Defining an ODBC Data Source

Before you can use Microsoft Access with a database server, you need to load the ODBC drivers. These drivers come with Access and are installed with the product. You also need to load drivers for the specific back-end database servers to which you want to connect. These drivers usually are purchased from the back-end database vendor and often come with a per-seat charge. This means that you must purchase a client license for each user who will connect to the remote data.

An ODBC data source is a user-defined name that points to a remote source of data. It contains all the properties of the data source that are necessary to communicate with data stored on a database server.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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