Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Location
    Oceanside,CA
    Posts
    31

    Unanswered: Linked files cause password prompt

    I have a Access 2000 DB with tables linked to a AS 400 database. When I run a query on the Access DB it prompts for a password. I do not want this prompt. Is there any way I can get rid of this prompt?

  2. #2
    Join Date
    Jan 2006
    Location
    New England
    Posts
    12
    Are you using a VBA connection string to connect to the server or straight DSN? Should be able to add in the user name/password there which would eliminate the prompting.

Posting Permissions

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