Every time I refresh a Microsoft Query I am prompted to enter Sage login credentials twice. Can I turn this off?
Every time I refresh a Microsoft Query I am prompted to enter Sage login credentials twice. Can I turn this off?
Not sure if this will work for you but you can always create a Silent DSN.
i dont know what that is?
A silent ODBC connection allows you to copy the Sage 100 ODBC DNS connection (SOTAMAS90) but specify the Company code and login to be used when making that connection.
The following articles may be helpful from our Sage Knowledgebase (https://support.na.sage.com/ ):
How to create a silent connection to an ODBC data source (article # 19495)
How to import data into Microsoft Access or Excel from Sage 100 (article # 51308)
https://csa-support.na.sage.com/knowledgecentral/viewdocument.do?noCount=true&externalId=51308&sliceId=2&isLoadPublishedVer=&docType=kc&docTypeID=DT_Article&stateId=5701&cmd=displayKC&dialogID=59062&ViewedDocsListHelper=com.kanisa.apps.common.BaseViewedDocsListHelperImpl&openedFromSearchResults=true
I have posted a few examples so just search if you don't have access to Sage Knowledge Base
*Community Hub is the new name for Sage City