[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
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.
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.