Simple 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. I'm converting an
Access 2000 project to a SQL Server back end.

Thanks,

JM

Nov 13 '05 #1

JM

Sorry for the dual post. 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.

Nov 13 '05 #2