Hi Mike,
For no particular reason other than "I tried, but it did not work". Did not give it more thought, but I suspect me :), Access or ODBC in order of probability.
Regards,
Marc
>Mark,
>
>Why are you using the SQL insert to add a record instead of ADO's native .addnew and .update?
>
>Just curious,
>Mike
>
If things have the tendency to go your way, do not worry. It won't last. Jules Renard.