Simple Query to Linked ODBC table gives wrong results

J

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
 
J

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query to Linked ODBC table gives wrong results 1
SQL syntax for Access Pass Through queries (ODBC) 4
Slow ODBC Queries to SQL 2000 4
Replace existing tables with links to ODBC sources 3
query links to SQL server and mdb table 1
ODBC error on linked SQL server table, by Access 2003 0
ODBC Connection problems 3
Linked SQL 2000 Table and Query Problem 0

Top