J
JMcquillan
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?
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?