So what you need to do is change the name of that column in Access and in
the code.
At 04:45 PM 4/20/00 -0400, you wrote:
>DATE is a reserved word.
>
>Chris Evans
>[EMAIL PROTECTED]
>http://www.fuseware.com
>
>
>-----Original Message-----
>From: Shawn Regan [mailto:[EMAIL PROTECTED]]
>Sent: Thursday, April 20, 2000 4:43 PM
>To: '[EMAIL PROTECTED]'
>Subject: can anyone see anything wrong with this?
>
>
>This message is in MIME format. Since your mail reader does not understand
>this format, some or all of this message may not be legible.
>
>------_=_NextPart_001_01BFAB09.1517DF80
>Content-Type: text/plain;
> charset="iso-8859-1"
>
>Anyone see anything wrong with this?
>
>
>SQL = "UPDATE CARD SET OUT='7:00' WHERE EMP_ID='5955' AND DATE='04/19/00'
>AND IN='9:00'"
>
>
>
>ERROR BEWLOW
>
>
>Error Diagnostic Information
>ODBC Error Code = 37000 (Syntax error or access violation)
>
>
>[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in
>query expression 'EMP_ID='5955' AND DATE='04/19/00' AND IN='9:00''.
>
>
>SQL = "UPDATE CARD SET OUT='7:00' WHERE EMP_ID='5955' AND DATE='04/19/00'
>AND IN='9:00'"
>
>
>
>TIA
>Shawn Regan
>
>------_=_NextPart_001_01BFAB09.1517DF80
>Content-Type: text/html;
> charset="iso-8859-1"
>Content-Transfer-Encoding: quoted-printable
>
><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
>can anyone see anything wrong with this?
>
>Anyone see anything wrong with this?
>
>SQL =3D "UPDATE CARD SET OUT=3D'7:00' WHERE = EMP_ID=3D'5955' AND
>DATE=3D'04/19/00' AND IN=3D'9:00'"
>
>
>ERROR BEWLOW
>
>Error Diagnostic Information
>ODBC Error Code =3D 37000 (Syntax error or access = violation)
>
>[Microsoft][ODBC Microsoft Access Driver] Syntax = error (missing
>operator) in query expression 'EMP_ID=3D'5955' AND = DATE=3D'04/19/00' AND
>IN=3D'9:00''.
>
>SQL =3D "UPDATE CARD SET OUT=3D'7:00' WHERE = EMP_ID=3D'5955' AND
>DATE=3D'04/19/00' AND IN=3D'9:00'"
>
>
>TIA
>Shawn Regan
>------_=_NextPart_001_01BFAB09.1517DF80--
>----------------------------------------------------------------------------
>--
>Archives: http://www.eGroups.com/list/cf-talk
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
>
>
>------------------------------------------------------------------------------
>Archives: http://www.eGroups.com/list/cf-talk
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.