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

    Remote SQL Server Password

    Hello,



    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
    Location
    Somerset, UK
    Posts
    4,070
    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
  •  
Tech Forums: Microsoft Office Forums