I use SQLSTRINGCONNECT to establish a connection with Access97/2000 databases.
I then use SQLEXEC to send an SQL Select statement to the Access97/2000 backend.
The SQL-SELECT syntax is not EXACTLY the same as VFP'S SQL-SELECT syntax. I am able to muddle through the syntax differences on complex queries by building remote views to the Access tables and noting the differences in the "VIEW SQL" window of the view designer. This is unsatisfactory for my purposes. I would like to know where I can obtain documentation on the SQL Syntax Access97/2000 is expecting. Also, where could I find documentation on the SQL Syntax that SQL Server is expecting?

Any ideas?