1) use file DSN (can be deleted after linked tables are created).

2) If using a trusted connection without a password being saved in Microsoft Access system tables, use the following template:

DRIVER=SQL Server Native Client 11.0
Regional=Yes
Encrypt=Yes
DATABASE=AdventureWorks
WSID=MyWorkstationName
APP=Microsoft Office
Trusted_Connection=Yes
SERVER=SQLServerHostName\SQLServerInstanceName
Description=Whatever Description You Like
TrustServerCertificate=Yes

No Comments

You must log on to comment.