Access 97 SQL Reference

[Amy Blankenship]

Hi, all;

I've depended for years on the Access 97 SQL reference on MSDN, as nothing
like it seems to exist for more recent versions. Today when I tried to get
to it, the page wasn't there and the Access 97 section of the archive was
severely truncated, so there is no way to find it by hand. Anyone know of
an Access SQL reference as good as that one?

TAI;

Amy

 

[strive4peace]

Hi Amy,

don't know about comparisons, but here are some links for SQL:

Introduction to SQL
http://www.w3schools.com/sql/sql_intro.asp
~~~~
SQL in a Nutshell
By Kevin Kline with Daniel Kline, Ph.D.
January 2001
1-56592-744-3, Order Number: 7443
224 pages, $29.95

Chapter 4
SQL Functions
http://www.oreilly.com/catalog/sqlnut/chapter/ch04.html

~~~~
About SQL
John Paul Ashenfelter
http://www.oreillynet.com/pub/ct/19
~~~~

SQL Tutorial
http://www.1keydata.com/sql/sql.html

~~~~

Introduction to Structured Query Language Version 4.67
by James Hoffman
http://riki-lb1.vet.ohio-state.edu/mqlin/computec/tutorials/SQLTutorial.htm
~~~~

SQL Reference and Examples
Larry Truett
http://fluffycat.com/sql/

~~~~~~~~~~~~
and an index of lots of SQL reference links -- which the above mostly
came from...
http://r937.com/sqllinks.cfm

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

 

[Amy Blankenship]

Thanks, but none of these include SQL statements that allow you to transfer
data from one db to another like select into TableName [in database]

 

[Nick Coe \(UK\)]

Doesn't the Access 97 Help file describe this and more?
It's called ACMAIN80.HLP

If you haven't got that on your PC then I'm afraid you'll
have to try and find an old MSDN cd with the Acc97 SQL stuff
on or I s'pose a copy of A97.

I have to say I'm a bit surprised MSFT kept the A97 stuff
online this long. It is after all long since superseded by
later versions of Access. Having said that I still use the
A97 help since it's a damn sight easier to find stuff than
the later versions. There are of course some useful
functions like Split() which turn up in later versions and
aren't covered by the A97 info...

--
Nick Coe (UK)
http://www.alphacos.co.uk/




In Amy Blankenship typed:

 

[Jim whitaker]

Rogers access library, I forget the url. There's some excellant examples of
sql.

 

[strive4peace]

www.rogersaccesslibrary.com


Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*