Hi all!
I put this out on the Access forum, and haven't gotten a response so maybe this is the correct place for it.

Using Access as a front end, I've linked to a multitude of SQL Server tables, via an ODBC connection with SQL server authentication. If I open a table, I can edit data within the column without any problem. When I try using a recordset within VBA (I created a button on a form to execute a loop), everything works until it gets to the .update statement. It then tells me the ODBC call failed.

Please help!

Thanks in advance.


dartcoach

__________________
dartcoach

Found the problem - I was only trapping 1 error. Once I trapped the others, it showed me how to fix.


dartcoach