Cant get SQL Statment to work

P

parlec

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.
 
G

Greg Collins

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.
 
S

S.Y.M. Wong-A-Ton

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 *.
 
Top