[AccessD] ADO Problem

I'll have him give it a try.

Rocky


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gary Kjos
Sent: Tuesday, November 28, 2006 10:34 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] ADO Problem

Don't know DAO at all but don't you usually have # signs around dates
in SQL statements to mean Date Format enclosed.

GK

On 11/28/06, Beach Access Software <bchacc at san.rr.com> wrote:
> Dear List:
>
> A colleague (who thinks I know ADO) writes in to ask why the following:
>
>  Conn.Execute "INSERT INTO tWeeklyUpdateSent ( DateSent ) " & _
>  "SELECT " & dtToday & ""
>
> Inserts a record into tWeeklyUpdateSent so the conection is OK.  But but
the
> date is 1/1/1900 instead of today's date.
>
> I had him check the contents of dtToday and it does indeed have 11/28/2006
> in it.
>
> Does anyone see what he's doing wrong here?
>
>
> MTIA
>
> Rocky
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


-- 
Gary Kjos
garykjos at gmail.com
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.430 / Virus Database: 268.14.19/555 - Release Date: 11/27/2006
6:09 PM