Knowledgebase: Tutorials
[QODBC-Desktop] Troubleshooting - How can I get a single user access using QODBC connection string
Posted by Jack - QODBC Support on 11 January 2016 10:01 AM

Troubleshooting - How can I get single-user access using the QODBC connection string

Problem Description:

I am in access and need to update the Inventory. I have made a table that contains the adjustments. (Thousands of them) Your notes about InventoryAdjustmentLine state that I must be in single-user mode to do this. What is the connection string that I must use? When I connect in QuickBooks, I currently login as administrator and auto-connect to access.  

Solution:

QODBC uses QuickBooks SDK to communicate with QuickBooks Company files. QODBC can perform only that operation that is available via QBSDK.

No option/function will change QuickBooks company to switch the company file to single-user or multi-user access.

Yes, If no one is using the QuickBooks company file, you may connect to the QuickBooks Company file in "Single user mode" or "Multi-user mode."

You may either use the Connection string or specify OpenMode = F (Follow Company) / M (Multi-user) / S (Single-user) or Change the Open File Mode from QODBC Setup Screen.



For the connection string, please refer to How do I build a connection string with all the available QODBC parameters / Connection String with QODBC Parameters.

(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).