Ger,
>SQLEXEC(lnAccess, "UPDATE mytable SET mytable.name = 'Test Name' WHERE mytable.filename = ?tmpdata.filename .AND. mytable.filenum = ?tmpdata.filenum")
The SQL command must either be written in generic ODBC syntax or in the syntax of the target database system. Just remove the dots around the .AND. and it should work.
HTH,
Armin