Linked SQL Table - Can't Read

[DavidES]

I'm using Access2003.
I have created a DSN for my SQL Server 2008 table.
I have added the table as a linked table but when I query the table, all I
see is #NAME? in each row and field.

If I write a Pass Through Query using the same DSN and the same criteria, it
works fine.

Here's my query:
SELECT dbo_ITEMS.ORDERNO, dbo_ITEMS.ITEM_ID, dbo_ITEMS.ITEM
FROM dbo_ITEMS
WHERE (((dbo_ITEMS.ORDERNO)=142011));

Any ideas what is wrong?

 

[Sylvain Lafontaine]

Do you have a primary key (or an unique index) defined for this table and if
so, is its type one of the incompatible types with Access such as BIGINT?

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)

 

[DavidES]

The primary key is a number - decimal field - 12 digits. I don't see any
reference to BIGINT.