Ciao! 1) Sorry for my poor english. 2) I have this problem with ADO: With Data Environment I'm connecting to an Access97 db. With VB6 I have no problem when I use dataenv.recordset.update after used .addnew. The problem is when I use .update alone (when I modify a record, I think!). Error : -2147467259 (!!) "Query too complex" (??) I know that the .edit like DAO, doesn't exit anymore with ADO. I'm wrong?
Help me pls! Greeting from Italy Mirko
Sun, 01 Dec 2002 03:00:00 GMT
Sol Shapi #2 / 2
ADO : Query too complex (or something similar!)
Mirko,
The query is more than likely TOO AMBIGOUS. I.e. can apply to many records so SQL does not know which one to select/update.
Sol.
Quote:
>Ciao! >1) Sorry for my poor english. >2) I have this problem with ADO: >With Data Environment I'm connecting to an Access97 db. >With VB6 I have no problem when I use dataenv.recordset.update after >used .addnew. The problem is when I use .update alone (when I modify a >record, I think!). Error : -2147467259 (!!) "Query too complex" (??) >I know that the .edit like DAO, doesn't exit anymore with ADO. I'm wrong?
ADO : Query too complex (or something similar!)