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

RickatEaton
pts.
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.....
Asked: Last updated:
Related Questions

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.
  • 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.

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

Following

Share this item with your network: