I just need to refresh it so that a couple of the columns are updated with new numbers. Is there a way to use TBetter Ado here that would solve my problem? [OLE/DB provider returned message: Insufficient base table information for updating or refreshing.] OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowset Change:: Set Data returned 0x80004005: ].There are a couple of instances on this form where I need to refresh the dataset.When I do so I get "insufficient key column information for updating or refreshing" If I set the dataset to active = false and turn it on again that works fine but I really don't want to do that. Source = "SELECT * From received ORDER BY received. I can see records in the MDB, using Adodc and datagrid. Update I got the "Insufficient base table information for updating or refreshing" message. Rgds, Bernard here is the way I open the MDB: In General/Declarations: Private With Events global Connection As ADODB. Recordset In the Form_Load() global Provider = "Provider= Microsoft. OLEDB.3.51;" global Data Source = "Data Source=" & Text10 ' Text10 contains the path to the network volume where the MDB is located global Connect = global Provider & global Data Source Set global Connection = New ADODB.
I have a TAdo Dataset that uses a couple of MS SQL 2k views as the datasource (inner joined). The final result returns columns that include the primary key of one of the base tables and the rows that are returned are absolutley unique. I am able to navigate the grid that displays the dataset without any trouble.
The grid is not editable of course because the data source is too complex.