what type of SQL is used in Access?

[leok31]

Sorry if this seems like a weird questions but I was unable to find much on this, but what is the type of SQL that Access accepts?
I'm familiar with SQL Server which uses T-SQL. I just want to know if there are any functions which are available to Access SQL but not in normal SQL

 

[CJ_London]

Access JET/ACE defaults to ANSI89

http://office.microsoft.com/en-gb/access-help/about-ansi-sql-query-mode-mdb-HP003070483.aspx

But you can change this the ANSI92 which may have some benefits depending on what you want to do.

The above link should explain in more detail.