hi everyone, I am having a very similar issue. Was there ever a resolution?

I get the same error number -2147217887 but with this error message "ODBC--call failed.". I get this when I try to execute an rst.Update. I have an MS Access 2013 application using an ODBC connection to SQL Server 2008 r2. I am using a query to update a table. It is a simple Select query with no joins. I have checked to make sure the table can be updated.

Can anyone help me here?