Documentation for Jet SQL?

  • Thread starter Thread starter Dean Dei Cas
  • Start date Start date
D

Dean Dei Cas

I am looking for a Jet SQL reference document. Does any
on have an suggestions?

Background: I have just arrived at a client who is using
Access 7.00. It is my understanding that when using
Access's "native" database one is using "Jet". True? As
yet I have not been able to find an "SQL Reference" for
Jet similar to the SQL reference documents that I've used
from Oracle, Sybase, etc. Where would I find such a
document?

I have the O'Reilly "Access Database, Design & Programmng
which is useful but not an SQL reference
 
If you have M$ Access installed on your machine
DriveLetter:\Program Files\Microsoft Office\Office\1033\JETSQL40.CHM
HTH,
Tim
 
Thanks you. Your answer solved my problem. Now I'm just
going to have to get used to the difference between Access
and "normal" SQL.
 
yet I have not been able to find an "SQL Reference" for
Jet similar to the SQL reference documents that I've used
Click to expand...

FWIW
Access 7 (Jet 3) only supports 'old' SQL.
Access 9+ (Jet 4) ALSO supports an ANSI 92 syntax

(david)
 
Back
Top