DBGrid with RDO (Visual Basic)

[nakheel]

Please advice!

I developed a project in vb6 with RDO. In one form using a combotext. I am executing a SQL query in a resultset and retrieving a set of records, and assigning that records to other table that table is connected to a grid through Remote data control. After assigning the records I am refreshing the remote data control. While refreshing it is raising the following run time error

Runtime error 2147467259 (80004005)
Could not refresh controls

With an remote data control error ( for the same code which is different for different time )

MSRDC1
S1109 [Microsoft][ODBC Microsoft Access Driver] Record is deleted.

(Or)

MSRDC1
Invalid result set state for Update

(Or)

MSRDC1
Invalid row for AddNew or Edit


I want to know how to overcome the problem it is really very urgent. Anybody who knows the answer please help me.

[Randman]

Sounds like either BOF or EOF is true
make sure you test for that. When the recordset wants to refresh or update it can't because its absolute position is BOF or EOF
make sure you are using the right edit and update syntax methods.
Q102681
Q129883
I hope this helps