I've linked my IDS 9.3 table into Access 2000 database and get an error when executing the following query.

SELECT informix_stkhstm.dated, informix_stkhstm.dated, informix_stkhstm.*
FROM informix_stkhstm
WHERE (((informix_stkhstm.dated)=#2/17/2004#) AND ((informix_stkhstm.dated)=DateValue("17/FEB/2004")));

informix_stkhstm.dated)=#2/17/2004# causes error message
Invalid month in date (#-1205).

My Client Locale is en_US.CP1252 so is my Database Locale.

The following query works fine.

SELECT informix_stkhstm.dated, informix_stkhstm.dated, informix_stkhstm.*
FROM informix_stkhstm
WHERE (((informix_stkhstm.dated)=DateValue("17/FEB/2004")));

Hi,
Please test in the Client, the environment variable DBDATE. (setnet32) or definition to ODBC drive.

Gustavo.

Thanks Gustavo that worked a treat.

Kelvin