Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Posts
    300

    Post 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?

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Yes you can. See: Connection Strings
    Have a nice day!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •