Access 2002/XP SQL-syntax reference 1

[rmuller]

Hi,

I am REALLY in trouble. I am working with Access 2002 and some simple queries do not work. (With other dbms they DO work). The error messages in Access are REALLY useless, so I am searching for the allowed SQL syntax. But it is NOT in the help files and i also cannot find it anywhere on the web.
So, who can help me? This information must be available somewhere (?!).

Ronald

 

[tlbroadbent]

Check the following links. Though they specify Access 2000, most syntax should still be applicable in Access 2002.

Fundamental Microsoft Jet SQL for Access 2000

http://msdn.microsoft.com/library/en-us/dnacc2k/html/acadvsql.asp

Intermediate Microsoft Jet SQL for Access 2000

http://msdn.microsoft.com/library/en-us/dnacc2k/html/acintsql.asp

Advanced Microsoft Jet SQL for Access 2000

http://msdn.microsoft.com/library/en-us/dnacc2k/html/acadvsql.asp

I frequently refer to the Microsoft Jet SQL Reference under the contect tab of Access Help. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.