Search code examples
ms-accessjet-sql

What is the proper way to refer to the SQL dialect used by Microsoft Access?

I'm converting some SQL that came from Microsoft Access into T-SQL, and I'm making note of these changes in my documentation. This has led me to ask, what is the proper way to refer to the SQL extension used by Access?

I've seen casual references to "Jet SQL" and "Access SQL," but I'm not confident that these are official or up-to-date.

Solution

  • Microsoft Corporation refers to it as "Microsoft Access SQL" in an Access 2013 help article:

    "Microsoft Access database engine SQL is generally ANSI-89 Level 1 compliant. However, certain ANSI SQL features are not implemented in Microsoft Access SQL. Conversely, Microsoft Access SQL includes reserved words and features not supported in ANSI SQL."

    -- Comparison of Microsoft Access SQL and ANSI SQL (http://msdn.microsoft.com/en-us/library/office/ff844937(v=office.15).aspx)