Troubles updating linked database
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.
Re: Troubles updating linked database