Try to use Access's CStr() function instead of DTOC().

>I get the following error when I try to run the code below:
>Connectivity error: [Microsoft][ODBC Microsoft Access Driver] Undefined function 'DTOC' in expression.
>
>Code
>
>lnResult = SQLEXEC( lnAccess,"INSERT INTO transaction "+;
> "([promono],[batch],[filename],[problem],[dateout])"+;
> " VALUES "+;
> "(?tmpdata.promono,?tmpdata.batch,?tmpdata.filename,?tmpdata.problem,DTOC(?tmpdata.dateout))" )
>
>If I leave out the DTOC I get a data type mismatch. The field in access
>is a date/time field and the VFP field is a datetime field.