VB Forum / Database Access / March 2006

I have an Access database with a LOG table that has a DATE_TIME field that
is a Date/Time data type.  When I look in the database with Access there are
a bunch of records with the value 11/8/2005 11:28:15 AM in the DATE_TIME
field.  However, when I use ADO to .Find a record with that value like:
       rsDestination.Find ("DATE_TIME = #" & dtTemp & "#")
where dtTemp = 11/8/2005 11:28:15 AM , the recordset returns a .eof, finding
none of the records.  But there are plenty of them there as my code has been
adding them since it thinks none are there.  Interestingly, within Access
itself if I open the table, point into the column DATE_TIME and do a Find
with Access, it finds them HOWEVER if I uncheck the "Search Fields as
FOrmatted" box, then it does NOT find any.

A query such as SELECT LOG.DATE_TIME FROM LOG WHERE
(((LOG.DATE_TIME)=#11/8/2005 11:28:15#)); also finds NO RECORDS, even though
I can see them.

Any ideas what is wrong with the database?  Or my SQL statement?  Or my Find
statement?