Ger,
If SQLExec() returns 0, use AERROR() to get more information about the ODBC errors you are getting. The values in the result array will help you figure out what's wrong with the SQL statement, or what errors got thrown by the backend.
>SQLEXEC(lnAccess, "UPDATE mytable SET mytable.name = 'Test Name' WHERE (mytable.filename = tmpdata.filename)","Mytable")
>
>
>I have a foxpro table tmpdata which was created by importing
>data from an access table mytable. I change some values and
>want to write back to the access table. But nothing happens.