Ger,

Did you try what I suggested in your other thread last week? You really must check the return value of SQLExec() and if it fails use aerror() to get more detailed information about what is wrong with your SQL statement or why the backend is refusing to do the insert.

>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?