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