Avatar of Richard Korts
Richard Korts
Flag for United States of America asked on

Access Linked to Quick Books

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.

QuickBooksMicrosoft Access

Avatar of undefined
Last Comment
Richard Korts

8/22/2022 - Mon
Scott McDaniel (EE MVE )

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Richard Korts

This has linked tables. Is there a way I can "see" the userid & password used?

Also, the issues seems to be connected to the fact that the overnight mechanism uses QB in "Single User" mode, whereas if another user is using QB, it is in multiuser mode.

I cannot detect any connection user / password from properties on the queries.

Don't know what to do.

Richard Korts

FYI, this is MS Access 2003.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck