Forest Dragon
Sep 22nd, 2000, 05:27 AM
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!
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!