Automation Errors WHY are they happening!

[Thom]

OK, I'm using disconnected recordsets to build new tests, and just recently while testing I noticed that sometimes my VB6.0 app during an Addnew or MoveNext method will bomb out with "Automation Error -21471217842, Operation Cancelled"!!!!

WHY! does this happen? Does anyone have a clue? I've noticed that if I'm typing in a bound textbox(bound to rs1.QuestionFiled) If I click away & then go back into the textbox and change the text(delete a few words, or add some) AND then Click on the Save/Update Record button it happens more frequently!

Is there any way I can error trap for this to avoid the situation where a record is SAVED but there is NO entry in the bound Textbox!! What's going on?? I'd appreciate ANY help!

Back in the misty reaches of the dawn of Time (Windows 3.1) the same thing would happen to me using Access and an Oracle connection.

Essentially, the OS would change state, the Oracle database would return a result, and Access would blow its little brains out because the state was not as expected.

An equivalent situation in DOS was when a program would monkey around with stack.

If you are connected to a network device, AND the device is slow then you might get this type of error. It certainly doesn't sound like a VB error, because it's flaky (non-repreducible).

I haven't the vaguest idea how to handle this.

Good Luck
DerFarm

[sanon]

Hi Thom,

You said in the first line that you used a disconnected recordset. That may be your problem. Everytime you edit and/or update a record, don't forget to refresh your recordset so that you can have update data.