Access database linked with password protected SQL server

[Jenkins27]

I am currently trying to open a access table and my code keeps bugging out with "ODBC connection to db failed". I know it is because the SQL server requires a username and password but I'm not sure how to code that in the connection string for an access DB. Here is a part of my code! thanks for the help

Please Login or Register  to view this content.

[grimes0332]

'Access' and 'SQL Server' are 2 different products and your post is not clear if you are simply trying to connect to an Acess database (with 'normal' Access format tables) or an Access database with linked SQL Server tables.

If it's purely Access then you can get example connection strings here, including examples with user ID and passwords.

[Jenkins27]

I'm sorry it is a Access database with linked SQL Server tables and the SQL Server tables require a username and password. Thank you

[grimes0332]

I would have thought the user ID and password would have been stored in the DSN for the SQL DB... but not easy to be certain remotely with an issue like this.

This page shows how to create linked tables without using a DSN - even if you decide not to go down that route, there may be some useful information on the page as it shows connection strings with UID and PWD parameters included.