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?