Where can I find a complete reference for Microsoft Access SQL? [closed]

Question

I am looking for a definite reference of the SQL as understood by Microsoft Access. All the links I can find talk only about bits and pieces. Ideally I am looking for a grammar specification with details of what all the different keywords do.

Motivation: I am trying to write my own parser for Microsoft Access SQL statements.

Answer 1

Open MS Access, go to a module and open it, bringing up the Code Editor. In the code editor, choose Help > Microsoft Visual Basic Help. Now choose 'Microsoft Jet SQL Reference'.

I will soon be releasing a library that includes a JET SQL parser. It enhances JET SQL to provide all of the DDL functions not currently available in SQL, and offers automated back end update using a version number and version update scripts.

EDIT: Of course, I forgot that they've probably screwed all this up in later versions of Office.

I checked and the above works in Access 2003 (the last usable version of Access, which I still use for development) and Access 2007. Noting you MUST be in the code window, not the main Access database window!

In Access 2013, this has all moved to the web. However it looks like there is still a 'Developer Reference' link on the web page, and this takes you to a page substantially like the offline one. After clicking some links I'm ending up at: msdn.microsoft.com/en-us/library/dn142571.aspx

Hopefully since this is Access 2013, the link won't die too soon.

Answer 2

I just did a quick Google search and found this:

• Microsoft Jet SQL Reference (Access 2003)
• Microsoft Jet SQL Reference (Access 2007)

To me this looks like what you wanted, or are these some of the "only bits and pieces" links that you already found?