Link to home
Start Free TrialLog in
Avatar of Richard Korts
Richard KortsFlag 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.

Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of 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.

FYI, this is MS Access 2003.