Hi every body,

Thanks for the reply. I have got a problem with access DATETIME fields. While they have none blank values they work great. However, when I try to empty a DATETIME Access field through ODBC in VFP6, I get the following error:

Connectivity error: [Microsoft][ODBC Microsoft Access Driver]
Data type mismatch in criteria expression.

How can I fix this problem?

Thank you,
Ali





>>Hi every body,
>>
>>I have a question for you. I am accessing an Access database through ODBC. What is the equivalent of ‘Short Date’ in FoxPro?
>>
>>Thank you,
>Ali,
>
>You can run select through ODBC and check what data type FoxPro uses for a ‘Short Date’ field in the cursor created.