An Introduction to Using Jet SQL in Access

Learn How Access Takes Advantage of Jet SQL
  • Susan Sales Harkins
  • Martin W. P. Reid


There are four types of Jet SQL users in Access:
  • Those who are completely oblivious to its existence and subsequently don’t know Access is using Jet SQL.

  • Those who know Jet SQL exists but don’t know anything about it.

  • Access users who can manipulate Jet SQL statements in Access and/or Visual Basic for Applications (VBA), the programming language that comes with Access (and Office) code.

  • Developers who know more than one version of Jet SQL and use it in Access and beyond.

Access uses SQL every time you run a query. (From here on, references to SQL mean Jet SQL, unless otherwise noted.) You create questions using the Query Design window, and, when you run that query, SQL converts your question into the format that the Microsoft Jet database engine (or Jet) can understand. You just don’t realize it’s happening because Access and SQL work together seamlessly.


Error Message Design Grid Select Query Design View Connection Object 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Susan Sales Harkins and Martin W.P. Reid 2002

Authors and Affiliations

  • Susan Sales Harkins
  • Martin W. P. Reid

There are no affiliations available

Personalised recommendations