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. ...
Get Alison Balter's Mastering Access 2002 Enterprise Development now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
