By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,501 Members | 2,805 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,501 IT Pros & Developers. It's quick & easy.

Simple Query to Linked ODBC table gives wrong results

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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

This discussion thread is closed

Replies have been disabled for this discussion.