Linking to SQL Server tables using Access 97 in Windows XP

  • Thread starter Thread starter Jack
  • Start date Start date
J

Jack

A user has to enter his SQL Server login/password
every time he executes a Microsoft Access query from
Access tables linked to an SQL Server database.
He is using Access 97 in a Windows XP machine. The
back-end SQL Server database is SQL Server 7.0.

This was not an issue in Windows 98: When creating a link
to a SQL Server database, there was the option to use
Windows NT Authentication.

Is there a way to imbed the SQL Server userid and password
when creating the Access links?
 
Try deleting the table link, and then re-creating the link. You will see a
option to "remember" the password when you create the link. Not the best
from a security point, but it does the trick.
 
Back
Top