Haunted table

[bobfin]

I have several ODBC tables linked to an Access 2003 database. The tables are all from the same SQL Server 2000 database. Queries work fine with all the tables except one. With that table, if I specify a fixed value for a field, the query results show many values for that field. If I run a query several times in a row, I get different results. When I put in sorting criteria, the results are not sorted correctly. But if I run the equivalent queries in SQL Query Analyzer, the results are OK. My boss gets similar behavior when he runs Access queries on this table. In all my years working with Access, I've never seen anything like this before. Does anyone have any clue as to what's going on?

 

[bobfin]

The source of the problem was that, during the creation of the link, not enough fields were selected as the primary key of the table. Since the key was not unique, odd results were produced by the queries. Finding the right combo of fields seems to have solved the problem. Thanks for suggesting the relink.