Somebody please help me, Arthur, come to my rescue again! Herein lies my plight:

I am using the rs.open (argument list) method to pass a Query to an Access
database and for ages I couldn't figure out what was happening but it seems
that Access is switching around my date formats. In the table I am querying
the date is stored in the UK format (dd/mm/yyyy). Now, if I pass a query
where the WHERE clause requires a date of, for example, 25/07/2003 then it
the query retrieves a recordset with the appropriate information in it. However,
if I pass a query where the WHERE clause requires a date of, for example,
06/08/2002 then, even though there are matching records for that date, the
recordset is empty.

To try and diagnose the problem I pasted my SQL String direct from VB into
the SQL view whilst designing a query in access. The Query appears as follows:
"SELECT * FROM tbl_data WHERE Date = #06/08/2002#". When I then change over
to have a look at the design view of the query Access lists the criteria
for date as 08/06/2002 (in other words, Access converts the date I have passed
it in the query to US format (MM/DD/YYYY). When I tried that with a date
like 25/02/2002, Access didn't convert it at all.

Anyone? (Answers preferably not on a postcard!)