Excel spreadsheet data refresh from AS/400 through Client Access Express.

Tags:
Help Desk
I am creating Excel spreadsheets that are populuated with data from the AS/400. When I perform the refresh data option from inside Excel from my PC, it works properly. When I forward the spreadsheet to a user, the ODBC window pops up asking that the password be entered for my USERID. It should use the cached user USERID and password. I have changed the ODBC link from the users PC but the prompt still appears. Thanks in advance for your help.....

Answer Wiki

Thanks. We'll let you know when a new response is added.

Did you use USER or SYSTEM DSN?

It will prefer to use USER DSN, so everytime
the same user login to windows, it will use
the stored username and password

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • RickatEaton
    We are using USER DNS. Even if the user is already signed onto the AS/400, it prompts for USERID and password with my USERID as the default not the user signed onto the system.
    0 pointsBadges:
    report
  • Howard2nd
    Preferred setupis "SystemDSN" for shared connections. Otherwise every user has to do the setup on every machine they use.
    30 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following