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

Chapter 11. Developing an MDB Client/Ser... > How Linked Table Applications Work

How Linked Table Applications Work

When you include linked tables in your application, Access's Jet Engine uses Open Database Connectivity (ODBC) to communicate with the client/server database. When a user submits a query based on a table that is linked to a client/server database, Jet converts the Access SQL stored in the query to an ODBC-compliant dialect of SQL. It then submits the SQL statement, as well as connection information, to the ODBC Driver Manager. The ODBC Driver Manager loads the appropriate ODBC driver and passes the driver the instructions necessary to execute the SQL statement. The ODBC driver translates the ODBC-compliant SQL statement to DBMS-specific (database management system–specific) SQL that the particular back end understands.

To make the process simpler, a tool called the ODBC Data Source Administrator allows you to create an ODBC data source. The ODBC data source stores important information about the database in a neat package. An ODBC data source contains information such as the name of the database server, the name of the database that you are connecting to, and login and security information. Once created, many applications can share a data source. As you will see, this chapter covers many uses of the ODBC data source.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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