Hunted and found this from you posted on the 17th.
I haven't seen the problem, so I can't say why you are experiencing it. As
I noted in my original reply, I would normally skip over this since my
knowledge in this area is limited. Things I would ask myself.
Are all the latest updates posted to your applications? (access 2003, SQL
2000)
Are the fields involved decimal fields? Or are any of the SQL 2000 fields
of the Big or Tiny types?
Have you tried using pass-through queries to see if that solves the problem?
Are you positive that your ODBC links point to the same SQL database as you
use when you run the queries in SQL?
Have you tried relinking the tables?
**** Original Message ****
From: "JMcquillan" <
[email protected]>
Subject: SQL Server 2000 link tables in Access 2003?
Date: Friday, November 17, 2006 8:41 AM
I have recently upgraded to Access 2003 from Access 2000. Prior to the
upgrade, I used Access with SQL Server 2000 linked tables to do a great deal
of simple reporting tasks and adhoc queries. Since the upgrade, I've found
that my SQL Server 2000 ODBC links are returning incorrect data. No errors,
no indication that anything is wrong, just results that are incorrect when
compared with the results produced when run in SQL directly. Other things
that are occurring running simple selects against link SQL 2000 tables in
Access 2003, group by functions result in repeating column data that is
incorrect & inconsistent results running the same query. Currently, I can't
trust access 2003 to work. Has anyone else experienced these issues? Is it
an
ODBC or Jet problem? Can anyone help?