[AccessD] Re: SQL Syntax in Access 2000

Robert L. Stewart rl_stewart at highstream.net
Wed Nov 12 14:05:51 CST 2003


Send your statement that is not working and we can tell you why it is not.

At 12:00 PM 11/12/2003 -0600, you wrote:
>Date: Wed, 12 Nov 2003 11:39:12 -0500
>From: Paul Liadis <pnl1 at psu.edu>
>Subject: [AccessD] SQL Syntax in Access 2000
>To: Access Developers discussion and problem solving
>         <accessd at databaseadvisors.com>
>Message-ID: <5.1.0.14.2.20031112113630.0346feb0 at mail.psu.edu>
>Content-Type: text/plain; charset="us-ascii"; format=flowed
>
>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,




More information about the AccessD mailing list