Operation must use an updatable query

Ok. Here's the deal. I'm trying to make my datacombo box to attach to my ADODC, but whenever I try to go to a different record or update with the update method, it tells me "Operation must use an updatable query". WHY? Even if I don't bind the list to it and just the normal DataSource and DataField properties to it, it still says that. It doesn't make sense! WHY? And I am using the DataCombo of the component Microsoft DataList Controls 6.0 . If that's the wrong one which one should I be using?

When you get that error it means you are using a query that cannot be updated.

For instance :

Code:

---

SELECT * FROM Table1 LEFT JOIN Table2 ON Table1.Field1 = Table2.Field1

---

As you can see above I cannot do an insert or update on this because it is a product of 2 tables and it is impossible to work out exactly WHAT you want stored in each record.

Cut'n'paste the Query you are using in here and I am sure you will see where you are going wrong.

It makes PERFECT sense if you actually understand SQL and Databases... If you are not 100% of what you are doing then invariably the answer is "Why??? It doesn't make sense... Why???"

Ok, I have a similar problem and doesn't make any sense either. Hope you could help me out:

I've been programming an app that reads/writes info from/into a database. It worked great while I was trying it with a MDB file. When I get to try it with linked DBF (as it should work to do what I need) I get the "Operation must use an updateable query."

The statement I'm trying to execute, e.g. is:

Code:

---

UPDATE Comb_R
SET Inscsiconf = 17
WHERE Curso = 'R3001' AND Cod_Mate = '950427'

---

And I get the annoying error message "Operation must use an updateable query.". What shall I do?

Notes: FYI, I'm using an ADO connection and 'Access 2000' MDBs files