I have inherited a situation where there is an Access database "linked" to a Quick Books database. There is a series of Access Macros & Queries that do specific tasks. The overall objective is to synchronize some f the Quick Books tables with an on-line web server database. The process runs nightly and has run since 2006.
We are now having issues, probably caused by changes I made.
I am trying to find out HOW the Access Macros, etc. log into Quick Books so I can change the login.
I cannot determine how that is done.
It starts by running the attached bat file (batb.bat).
The macro is in the attached jpg. I can of course provide more detail as needed, please advise.