How to prevent spreadsheets from prompting for password multiple times

How to prevent spreadsheets from prompting for password multiple times

Spreadsheets keep prompting for password over and over again


Click on Start, Programs, IBM i Access for Windows, System i Navigator

 

Right click on the left hand side on the “connection name”

Choose properties

 

Click connection

 

Remove the “prompt every time” radio button and select the “use default userid, prompt as needed” radio button. Put your AS400 userid in.

Click ok

Click ok again on this message

 

Your spreadsheets will refresh with only one userid/password prompt now.

 

    • Related Articles

    • Access for Windows Message CWBSY0002 Using Windows User Name and Password

      https://www-01.ibm.com/support/docview.wss?uid=nas8N1016498  The Access for Windows connection fails with the following message: CWBSY0002 - The password is not correct for the specified user ID. This occurs when the Use Windows user name and ...

    • Prompting up for password in the payroll spreadsheets when on LINQ server

        In the current version of LINQ (SQL server), unless you are a SQLSA customer, the payroll spreadsheets do not prompt for a password when you refresh. We are able to use your windows login so you are already authenticated to the server. If you are ...

    • Adding an iSeries Access Display and Printer session

      Adding a display session to a computer   Click on Start, programs, iSeries access for windows, Start or configure session.   Click “new session”   Be sure to select “properties” to choose SSL for secure sockets layer.     Choose Workstation ID  - ...

    • Configuring iSeries Navigator to use SSL

      Configuring iSeries Navigator to use SSL:       Click on Secure Sockets Click on  Download.     Password is ca400 (it is case sensitive).     C lick ok. Click on “Use Secure Sockets Layer and click ok.     You will get a message – click ok.    Close ...

    • Checking Version, Release and Service Pack level of iSeries Access

      Checking Version, Release, Service Pack Level of iSeries Access for Windows Click Start, Programs, IBM iAccess for Windows or iSeries Access for Windows Click on “IBM iAccess for Windows Properties” Read the second line down on the screen that ...