With ADO - I can read but not write - why?

[tcace]

Hello,

Using VB 6 with it's "ADODB" controls to connect with an Access MDB. The connection sets up fine, reads data no problem, even let's me search, etc.

But when I try to write data back, the error message is "Insufficient base table information for updating or refreshing."

If I use the exact same properties in code with an ADO Recordest object, it works fine - unfortunately, I need to use the built in ADODB control as the source for a DataGrid control.

What would cause this error and more important - is it easy to fix?

Thanks!!!
Todd

 

[Golom]

It is sometimes caused by using a server side rather than client side cursor. Unlike its DAO equivalent, the ADO DataGrid does not require a data control as its recordsource. You can specify an ADO recordset as the data source and it works just fine.

 

[tcace]

Golom,

I switched to an object based recordset in code and now it works fine.

Thanks!