In Access Client Solutions, I have green screen client sessions set up to default to MYPROFILE, which is nice.
We have some Excel .xlsx files, with several worksheets, each sheet within the .xslx has Queries & Connections (ODBC/SQL data gets) Properties.
When I refresh, the authentication box comes up with user QSECOFR.
After keying MYPROFILE (replacing QSECOFR) and password in 15 times (1 for each connection), I'm almost ready to call it a day!
Does anyone recall how to configure ACS to default to MYPROFILE, for this type of ODBC?
Rico
We have some Excel .xlsx files, with several worksheets, each sheet within the .xslx has Queries & Connections (ODBC/SQL data gets) Properties.
When I refresh, the authentication box comes up with user QSECOFR.
After keying MYPROFILE (replacing QSECOFR) and password in 15 times (1 for each connection), I'm almost ready to call it a day!
Does anyone recall how to configure ACS to default to MYPROFILE, for this type of ODBC?
Rico
Comment