Query to Linked ODBC table gives wrong results

[JM]

Hello,

A very simple select query (no joins) to a linked ODBC SQL Server 2000
table produces incorrect results. The right number of rows seem to be
returned, but some of the columns have incorrect values. I converted
the query to a pass-through, and it worked as expected. Does anybody
have an idea as to why this might happen? I'd rather leave the query
as Jet, because it's supposed to be updateable, and I think you cannot
bind pass-thru queries to forms. I'm converting an Access 2000 project
to a SQL Server back end.

Thanks,

JM

 

[JM]

I figured it out - when I linked up the SQL table, it asked for a
column or combination of columns for a unique identifier. The one I
provided was faulty. I created an identity column just for this
purpose, and things are good now. Thanks to all who answered.