Hello

I have a database that tracks changes made in a form use the second audit coding example from this site

http://www.datawright.com.au/access_..._in_access.htm

This was working until I moved my database to SQl Server 2008 express. Now I am getting the following error;

Run-time error '3146':
ODBC - call failed.

With the line .Update highlighted in yellow when I Debug. I have linked my SQL table to my access database. What code do I need to place their to update the SQL table?

Thanks in Advance.