Unanswered: Embed MS SQL userid password in ACCESS
I have created an ODBC connection to a MS SQL Server. The MS Access database contains about 50 tables linked to the server through this connection.
Everytime one of those tables is opened, or a query run that looks to the table.-- it asks for the user name and password.
Can I use VBA to code the connection information, user id and password , so the user is not prompted for this info?