dan.kre...@gmail.com wrote:
> This application worked like a charm with server 2000, but will not
> work with 2005. The application is trying to update through a cursor
> and an SQL Server ODBC and receives this error each time it tries to
> update "The cursor does not include the table being modified or the
> table is not updatable through the cursor." This appears to be a
> somewhat known issue, I've come across it many times in my search for
> a fix, but nobody seems to know a solution, other than re-writing the
> code. I did not write this application, and rewriting this method
> (which is used often) and recompiling is going to be an undesirable
> and expensive option, and writing scripts to work around will be
> impossible. I've been combing the internet for a solution... nothing
> has worked so far. I've tried:
>
> -Setting the compatibility of the database to 2000
> -Rolling back the MDAC 2.8 to a earlier edition. (this seems to be
> impossible, for whatever reason though, so I tried installing versions
> 2.7 then 2.6 over it, but it doesn't seem to have any effect).
>
> Any ideas?