Results 1 to 2 of 2
  1. #1
    Squeezeoj is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2019

    Remote SQL Server Password


    I have a local Access accdb file that links to tables on a remote MS SQL server.

    Every time I open the Access accdb file it asks for the remote MS SQL server's password. Is there a way to embed that into the opening so that I don't have to have users type / know that password?

    Thanks, Jason

  2. #2
    isladogs's Avatar
    isladogs is offline Very idle programmer
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Somerset, UK
    Use Windows authentication instead of SQL Server authentication
    Colin (Mendip Data Systems) : Website, email
    If this has helped, please click the star button and leave a comment

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Local Client with Remote accdb Server
    By Squeezeoj in forum Access
    Replies: 8
    Last Post: 08-01-2019, 08:38 AM
  2. Replies: 2
    Last Post: 06-11-2019, 09:47 AM
  3. ODBC with remote path to server
    By jaryszek in forum Programming
    Replies: 3
    Last Post: 06-01-2018, 04:19 AM
  4. Table fetching remote server
    By Manotosh in forum Access
    Replies: 2
    Last Post: 10-26-2011, 09:38 AM
  5. Getting date/time from remote server
    By mxfrail in forum Programming
    Replies: 4
    Last Post: 09-21-2009, 07:26 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums - Senior Forums