Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003

    Unanswered: Linked SQL Table Password

    I am using Access 2000 and in my database I have linked tables from a database on an SQL Server. Everytime I open and close Access and then run a query or try to open the linked table I am asked for my SQL user ID and Password. Is there a way to store this information so that I do not have to continue putting my ID and password ?

  2. #2
    Join Date
    Jun 2003
    yes, Im pretty sure you do it by ticking the "save password" box which appears somewhere during the process when you link the tables via the sql server odbc data source. This assumes you have the user id part of setting up the SQl server odbc data source done correctly.
    Try ticking the save password box whenlinking to the sql tables forst and see if that works.

Posting Permissions

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