Troubleshooting - QODBC Logging in with the Wrong User account

Problem Description:

I am using ms access. I have the integrated application certificate set up correctly (see screenshot). The username for this certificate is "odbc."



QuickBooks is closed.

Ms access file connects to QB via the connection string:

"ODBC;Driver={QODBC Driver for QuickBooks};DFQ=D:\QB\MyCompanyFile.qbw;OptimizerOn=No;IAppAutomaticLogin=n;OpenMode=F;OLE DB Services=-2;"

Connection works.

Another user tries to login in as "Admin" into QB on another computer, but it fails and says already logged in. See screenshot.



Why is QODBC using the "Admin" account?? I was expecting it to use the "odbc" account.

Solution:

You need to remove QODBC integrated application entries in QuickBooks & companyfilename. lgb and delete it to resolve the issue.

Please refer to Connection Lost Between QODBC and QuickBooks. QuickBooks Asking for Password for more details.