Ger,
Try the following:

?SQLEXEC(lnAccess, "INSERT INTO mytable (no, batch, filename) VALUES (?tmpdata.no,?tmpdata.batch,?tmpdata.filename)")

If the return value is -1, use AERROR() to check what went wrong.

HTH
>I have the following code for inserting a record into
>an access table, but nothing happens.
>
>SQLEXEC(lnAccess,"INSERT INTO mytable (mytable.no,mytable.batch,mytable.filename) VALUES (?tmpdata.no,?tmpdata.batch,?tmpdata.filename)", "Mytable")
>
>lnAccess is a valid connection.
>
>Anyone any ideas?