[AccessD] SQL Syntax in Access 2000

Jet SQL uses different wildcards and date delimiters than T-SQL.  My
favorite quick reference is Access Database Programming and Design from
O'Reilly.

Charlotte Foust

-----Original Message-----
From: Paul Liadis [mailto:pnl1 at psu.edu] 
Sent: Wednesday, November 12, 2003 8:39 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] SQL Syntax in Access 2000


Hi,
Is there a place where I can find the SQL syntax that Access uses in the

SQL view of a query?  I have an SQL statement that does an update in SQL

Server 2000 that will not run in Access (copy and paste to the SQL View)

due to a "syntax error".  Any help would be greatly appreciated. Thanks,

===============================================
Paul Liadis
Senior Applications Programmer/Analyst
University Budget Office
Pennsylvania State University

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com