Non-updatable Recordset?

[Zeee]

Good Day!

I have a query which uses data from different tables.
I use JOIN so that the recordset can be updated. If you run the query through MS Access 2000, you can easily edit the fields in the resulting recordset but if you run the query through VB6 ADODB 4.0(using the command object), the resulting recordset can't be updated. Worse, it generates a runtime error 3251 'The operation requested by the application is not supported by the provider'.
What am I doing wrong?

[Ianpbaker]

unfortunatley, you can't use any recordset object in VB to update tables in a JOIN statement. the way to get round it, is to find the primary key's of the two table's then use seperate recordset's to uppdate the records

Hope this helps

Ian