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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linked SQL Tables don't report Cascading Updates and Deletes 2
ODBC Linked tables keep on getting error 3151 5
Best way to deploy Access read-only database that is linked to SQL tables 6
Write Conflict in Access with SQL server Tables 3
Reconnecting Linked tables to SQL Server 2
Linked Tables and SQL Server permissions 3
SQL Server Back End 2
Relink of SQL Server tables in Access 2013 causes massive bloat 0

Top