The ADO Adapter failed to get the schema.
[0x80040E14][MSDataShape] Reference to column Equipment_Issue is ambiguous.
I get this error when I try to link the access to infopath form. I copied
one table to use it for another table with different info and it works just
fine. My other 7 tables wont pass SQL test when I include them.
Greg Collins - 28 Mar 2008 00:26 GMT
The term "ambiguous" normally means that there are more than one something
of the same name... in your case the column "Equipment_Issue".
That doesn't necessarily mean that the column name is used twice in the same
table... but maybe the way you've bound to the database, it is confused by
more than one column with this name.

Signature
Greg Collins
Microsoft MVP
Visit Braintrove at http://www.braintrove.com
Visit InfoPathDev at http://www.infopathdev.com
S.Y.M. Wong-A-Ton - 28 Mar 2008 06:15 GMT
You can make a column non-ambiguous by prepending the table name to the
column. For example, instead of "Equipment_Issue", use
"MyTable.Equipment_Issue" where MyTable is the name of the table in which the
Equipment_Issue column is located. The ambiguous column error can also take
place when you use a "SELECT * FROM..." and have joins to multiple tables. In
that case, it is best to explicitly specify each column you need in the
SELECT (including prepending the table name to the columns) instead of using
a *.
---
S.Y.M. Wong-A-Ton
> The ADO Adapter failed to get the schema.
> [0x80040E14][MSDataShape] Reference to column Equipment_Issue is ambiguous.
>
> I get this error when I try to link the access to infopath form. I copied
> one table to use it for another table with different info and it works just
> fine. My other 7 tables wont pass SQL test when I include them.