Execute a query (ADO)

[Forest Dragon]

Hello,

When I try to execute an Access query from VB by using the Execute method of the Connection object, I get the following error message:

Duplicate output destination "Makor"

The MSDN says it's because I have 2 or more fields with the same name in my query (it's an action query starting with "INSERT INTO"), but I have checked the query again and again and all the fields have different names. Moreover, when I try to execute that query from Access, I get no errors at all!

I think that maybe ADO has a problem with that particular field, but I can't figure that out.

Does anybody have any ideas how I can solve the problem?

Thanks!

What is the actual SQL you are trying to execute, and what is the structure of the table you are inserting into??

J.