MS Access and SQL Server

[Dean J Garrett]

We're developing a new MS Access 2003 application using a SQL Server 2000
back-end. The workstation running Access is Windows 2000 Workstation, and
the server running SQL Server is Windows 2003 Server Std.

We've been developing in this environment for weeks, but suddenly we're
seeing intermittant failures in connecting to the database. For example,
there is an Access form with a combobox. When we run the form and click to
pull-down the list, we see the error:

ODBC -- connection to TSDATA failed.

where TSDATA is the name of the ODBC DSN we're using to link SQL tables.
This error occurs in a variety of other places in the Access program we
developed, but this is the only place where it consistently yields this
error.

One thing we recenlty did was to replace the SQL Server user in the DSN from
"sa" to another user we created for the application. We don't see how that
could have affected this issue.

Any ideas!?!?! Thank you!!!!!

 

[Douglas J Steele]

When you changed the DSN, did you check that it still worked? Does the new
user have access to all of the necessary resources on the server?