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?