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 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) In your notes about InventoryAdjustmentLine, it states 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 log in as administrator and auto connect to access.  

Solution:

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

There is no option/function that will change QuickBooks company to switch the company file to the single user or multi-user access.

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

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



For connection string, please refer 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).