Results 1 to 3 of 3
  1. #1
    crimedog is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2013
    Posts
    141

    Linking Tables to Sql Password question

    I have an Access DB that utilizes linked tables from SQL. The DB has a login & Password for Read only access - let's say "login" "Password"


    got the tables linked, built my queries and formed - everything works great.
    Every time I reopen the Access Db, and a query looks at the Linked Tables - it gives a connection error:

    Code:
        Connection failedSQLState:'2800' SQL Server Error18456 login failed for user 
    I choose okay, the login dialog comes up - but it is trying to use my network login "CDog"
    I can change the user and login by unchecking "use trusted location"

    It would be fine but several people are going to use this - I need a way for Access to log in as "login" "password" without having to re enter it all the time


    Thanks

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    in widows control panel, open ODBC. (system utilities, odbc)
    Remove your connection to your server. Then add it back BUT set REMEMBER PASSWORD to true.
    Then it will remember them and not ask again.

  3. #3
    crimedog is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2013
    Posts
    141
    So if I store this on a network drive so the managers have access - when they opened it - would it have the same error for them?

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

Similar Threads

  1. Question about linking some tables together
    By photogwa in forum Database Design
    Replies: 2
    Last Post: 06-12-2015, 12:48 PM
  2. Question on properly linking tables
    By wsneeden in forum Database Design
    Replies: 4
    Last Post: 04-01-2014, 01:08 PM
  3. Linking to a password-proteced backend
    By ascii in forum Programming
    Replies: 8
    Last Post: 03-18-2014, 06:56 PM
  4. linking table in a password protected database
    By bdaniel in forum Programming
    Replies: 1
    Last Post: 01-04-2012, 01:25 AM
  5. Replies: 0
    Last Post: 03-04-2011, 10:28 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