K
k3639
I have an Access 2000 Database with an ODBC connection to SQL Server for
queries. The two users I am having trouble with were originally on Windows
2000, and were upgraded to Windows XP. As soon as the upgrade took place,
everytime they open the database query they have to re-establish the ODBC
connection, as it will not stay connected, but never had to in the past.
Also, occasionally the connection will drop in the middle of a query, and
they will have to start over again. I have tried deleting and re-creating
the File DSN, and have also tried connecting as a SystemDSN, but when I do, I
am given an error message referring to Microsoft Jet Admin, that the
connection is not allowed. Any suggestions as to why this is happening?
queries. The two users I am having trouble with were originally on Windows
2000, and were upgraded to Windows XP. As soon as the upgrade took place,
everytime they open the database query they have to re-establish the ODBC
connection, as it will not stay connected, but never had to in the past.
Also, occasionally the connection will drop in the middle of a query, and
they will have to start over again. I have tried deleting and re-creating
the File DSN, and have also tried connecting as a SystemDSN, but when I do, I
am given an error message referring to Microsoft Jet Admin, that the
connection is not allowed. Any suggestions as to why this is happening?