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
Linked Table Cant Delete Record 2
System resource exceeded with linked ODBC MS SQL 2000 table 1
linked table from ACCESS 3
Append query to ODBC linked table in SQL Server 19
Using ODBC Linked Tables 10
Trying to query ODBC source without linked table 2
Error 3157: "ODBC - update on a linked table <table name> failed 4

Top