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 MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Use Windows authentication instead of SQL Server authentication
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

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