Ik am using a microsoft database with two tables. One is a microsoft database and the other is a linked dBaseIV table. I can select data from both tables and I can combine them. I can also change the data in the tables but I cannot update a combined recordset. It there a way to do this?

I am using this recordset to create the combined recordset:

SELECT dBaseTable.columns, MSTable.columns FROM dBaseTable, MSTable WHERE dBaseTable.column=MSTable.column

When I enter a value in the Datagrid object it gives the following error:

'insufficient key data to update data" or something similar.