?"David-W-Fenton" wrote in message
news:Xns9E3CE797BDDE8f99a49ed1d0c49c5bbb2 (AT) 74 (DOT) 209.136.93...


If you have access 2003, from the VBA ide, go to help, and check out the
Microsoft JET sql reference.

That reference seems rather complete to me. The text is the same as 2010 to
my knowledge and includes the compression remarks and also has the same "see
also" links.

There might be some things missing, but from what I seen, it a rather nice
and complete reference.

I am not sure why someone was complaining, but perhaps it was someone who
did not have ms access, or did not bother to check the help file.

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
Pleasenospam_kallal (AT) msn (DOT) com

"Albert D. Kallal" <PleaseNOOOsPAMmkallal (AT) msn (DOT) com> wrote in
news:wA0Io.39569$8m.24342 (AT) newsfe09 (DOT) iad:

Indeed, it was someone who prefers to use Jet/ACE without Access
involved. And there is precious little documentation on exactly what
works in that environment as opposed to within Access.

Obviously, I can't offer much help myself in that scenario, so it is
something that concerns me. If there were proper documentation, I
think there'd be less kvetching about Jet/ACE/Access's non-standard
SQL implementation, for one.

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/