Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    May 2010
    Location
    San Juan, Puerto Rico
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have linked several tables in Access 2007 to SQL server 2008. I don''t want to use the trustee connection. Each time I open the access app, it prompt for the password in the ODBC conecction. Can I store this password somewhere in access?

  2. #2
    Star Lounger
    Join Date
    Sep 2002
    Location
    Hastings, Sussex, England
    Posts
    67
    Thanks
    0
    Thanked 1 Time in 1 Post
    Hi!

    When setting up the connection, the 'select tables' dialog box has a box for 'save password'. Tick the box. The password is then saved along with the other connection details.

    Regards,

    Jules

Posting Permissions

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