Linked Tables to SQL Server

D

Dave

I have an Access 2002 database that has linked tables to a SQL Server
database.

The ODBC connection is set up to use a SQL Server login account. Yet when
the user trys to run a report, he gets a message that the login failed for
his NT account.

How do I configure Access so that the connection always uses the SQL server
login? IOW, the Access database should be able to access the SQL Server
linked tables regardless of the NT account of the user.

Thanks for any ideas.
Dave
 
B

Brian

Dave said:
I have an Access 2002 database that has linked tables to a SQL Server
database.

The ODBC connection is set up to use a SQL Server login account. Yet when
the user trys to run a report, he gets a message that the login failed for
his NT account.

How do I configure Access so that the connection always uses the SQL server
login? IOW, the Access database should be able to access the SQL Server
linked tables regardless of the NT account of the user.

Thanks for any ideas.
Dave
Click to expand...

Did you check the "Save Password" box when you linked the tables?
 
Top