Insufficient base table information for updating or refreshing speed dating didsbury area

Posted by / 24-Jul-2020 11:26

Insufficient base table information for updating or refreshing

I only use table A to primary key to link primary B.

Should I have all the table B composite key fields in the select query? Inung Huang "Brian Bushay Team B" Does the table you are joining to have a primary key? If the joined to table doesn't have a primary key or has more fields in the key than you link to ADO will not be able to identify the joined to record.

Insufficient base table information for updating or refreshing. Insufficient key column information for updating or refreshing 10.

Hi All, context: I am using Access 97 tablkes with VB.

Insufficient Base Table Information For Updating Or Refreshing 4.

Insufficient base table information for updating or refreshing??? Insufficient base table information for updating or refreshing 3.

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. 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. VIEW_METADATA, for example: CREATE VIEW All Customers WITH VIEW_METADATA AS SELECT * FROM dbo.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? Customers And then if you use INSTEAD-OF-Triggers together with your view you can even directly insert/update/delete data.bye, Helmut writes I am not sure if this helps, but try to build your view with option WITH VIEW_METADATA, for example: CREATE VIEW All Customers WITH VIEW_METADATA AS SELECT * FROM dbo. I was trying to avoid that because it means that I also have to run several lines of code to reposition the selected grid row and such on that grid and then on the 2 detail grids. Data Source Hi Steve, Thanks for the tip but it must be something else. Can someone tell me what this runtime error means please. Insufficient base table information for updating or refreshing.

insufficient base table information for updating or refreshing-15insufficient base table information for updating or refreshing-32insufficient base table information for updating or refreshing-74

One thought on “insufficient base table information for updating or refreshing”