RE: ACS password prompt in Excel

Thanks Paul,

At least I know we’re not the only ones!

Thanks

Adam DRIVER
GTS/MKT/SSB/AS400
440 S. La Salle, 25th Floor
Chicago, IL 60605
Tel.: +1 312.762.1194
Cell: +1 224.250.9049
Team: +1 312.762.1125
Email: adam.driver@xxxxxxxxxx<mailto:adam.driver@xxxxxxxxxx>

www.sgcib.com<http://www.sgcib.com/>
Primary CI: AS400
Assignment Group: gts-wwi-ssb-app-as400
Team Email: amer-gts-mkt-ssb-as400-team
Tel (24 hrs): 312 762 1125

Any new support request should be sent to the first level at helpdesk@xxxxxxxxxxxxxxxxxxx<mailto:helpdesk@xxxxxxxxxxxxxxxxxxx>


[http://insite.fr.world.socgen/ecard/images/logo_legal_l.gif][http://insite.fr.world.socgen/ecard/images/logo_legal_r.gif]

From: Paul Therrien [mailto:paultherrien@xxxxxxxxxxxxxxxxxx]
Sent: Thursday, August 9, 2018 12:12 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Cc: DRIVER Adam ResgGtsMktSrv <adam.driver@xxxxxxxxxx>
Subject: Re: ACS password prompt in Excel


I too see this all of the time now and it is a pain, but we have no production spreadsheets where we need to download data.

I see it when i am doing ad-hoc queries in Excel.

With Client Access for Windows the connection stayed within the Excel session.

With Access Client Solutions the connection seems to need to be re-established for each query or even every time you modify the query.



Paul



On 2018-08-09 11:28, DRIVER Adam wrote:
Hi,

We have users with some huge spreadsheets pulling data from our PROD system. They have several hundred individual MS queries defined within them, no DSN set up, so Excel is handling the connection.

With IBM i Access for Windows, setting the Default profile and prompt once for each system meant it only prompted once when they did refresh all data. With ACS it prompts for each query within the spreadsheet, even with the same setting. IBM are no help, they say it's Excel, which I agree with, except it doesn't explain the difference between the different products.

Tested on both Windows 7 and Windows 10 BTW, same result.

Before we go and tell them they have to rewrite their spreadsheets, has anyone come across this?

Thanks

Adam DRIVER
GTS/MKT/SSB/AS400
440 S. La Salle, 25th Floor
Chicago, IL 60605
Tel.: +1 312.762.1194
Cell: +1 224.250.9049
Team: +1 312.762.1125
Email: adam.driver@xxxxxxxxxx<mailto:adam.driver@xxxxxxxxxx><mailto:adam.driver@xxxxxxxxxx<mailto:adam.driver@xxxxxxxxxx>>

www.sgcib.com<http://www.sgcib.com><http://www.sgcib.com/>
Primary CI: AS400
Assignment Group: gts-wwi-ssb-app-as400
Team Email: amer-gts-mkt-ssb-as400-team
Tel (24 hrs): 312 762 1125

Any new support request should be sent to the first level at helpdesk@xxxxxxxxxxxxxxxxxxx<mailto:helpdesk@xxxxxxxxxxxxxxxxxxx><mailto:helpdesk@xxxxxxxxxxxxxxxxxxx<mailto:helpdesk@xxxxxxxxxxxxxxxxxxx>>


[http://insite.fr.world.socgen/ecard/images/logo_legal_l.gif][http://insite.fr.world.socgen/ecard/images/logo_legal_r.gif]

*************************************************************************
This message and any attachments (the "message") are confidential, intended
solely for the addressee(s), and may contain legally privileged information.
Any unauthorized use or dissemination is prohibited. E-mails are susceptible
to alteration. Neither SOCIETE GENERALE nor any of its subsidiaries or
affiliates shall be liable for the message if altered, changed or falsified.
Please visit http://sgasdisclosure.com for important information regarding
SG Americas Securities, LLC ("SGAS"). Please visit http://swapdisclosure.sgcib.com
for important information regarding swap transactions with SOCIETE GENERALE.
*************************************************************************
*************************************************************************
This message and any attachments (the "message") are confidential, intended
solely for the addressee(s), and may contain legally privileged information.
Any unauthorized use or dissemination is prohibited. E-mails are susceptible
to alteration. Neither SOCIETE GENERALE nor any of its subsidiaries or
affiliates shall be liable for the message if altered, changed or falsified.
Please visit http://sgasdisclosure.com for important information regarding
SG Americas Securities, LLC (“SGAS”). Please visit http://swapdisclosure.sgcib.com
for important information regarding swap transactions with SOCIETE GENERALE.
*************************************************************************