Programmatic Fix for SQL Error 16943?

See more:

SQL-server-2000

SQL-Server

MFC

One of my program in VC++ uses the MS SQL Server 2000 as the DB and the app was coded in VC++ 6.0. The DB part was governed by the MFCs CRecordset and so on. The data is populated through the sequence as follows

1.CRecordset::AddNew();<br />
2.Fill all the columnar data of the record<br />
3.CRecordset::Update()

The problem now surfaces is, when the app running if the Optimization Job is done then the 3rd step throws the following SQL Error(By SQL Profiler)

Msg 16943, Level 16, State 4 Could not complete cursor operation because the table schema changed after the cursor was declared.

Moreover I am not using any of the cursors/Stored Procedures in my DB side.
Please help me out in fixing this. Thanks in advance. :)