We finally chased down the problem. One of the fields in the Access table was called 'GROUP' and, apparently, the Jett Engine parser was taking it as the reserved word 'group' (as in 'group by'), even though it was part of a string.

Have I mentioned my greatly increasing love for Access recently :)



>>Now I get a 'Data Type Mismatch' - oh, that layer o'love for Access is getting deeper.
>>
>>
>I don't have my MSACCESS programs with me - but I think the SQL can contain -
>
>CTOD("11/13/2001 15:10:03")
>
>Try That.
>If that don't fly, I look it it up tonight - and let you know tommorrow.
>>>>