Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
This message is showing up when I Try to connect my VB routine to Quick books, Exception: The Quick books company Data file is currently open in a mode other than the one specified by your application.
My databases is already working multi-user mode
I appreciate the input, @Laraque. I'll provide details regarding the networks you can utilize and point you in the right direction to help connect the VB routine to QuickBooks Desktop (QBDT).
Please note that the program supports Local Area Networks (LAN), Terminal Services, and Cloud Hosting. Therefore, you can access it within the extenders or hosts listed under these categories. Since the VB routine is a different program that can host or cater data, I highly recommend working with an IT professional. By doing so, they can help you reconfigure your setup to make your experience seamless.
For more information, you can check this reference: Recommended networks for QuickBooks.
Apart from that, I'm providing this handy article to give you insights into the possibilities that you can do with hosting QBDT data: Features available and tasks you can perform in single or multi-user mode in QuickBooks Desktop.
I'd then be happy to assist again if you need further clarification about data hosting, networking your data, or when other questions about QuickBooks arise. Let me know in the comment section below so I can promptly.
Hi , Thanks for your answer , but is not a networking problem, network is working fine, I create a Visual Basic Routine in Excel in order to search information on Quickbooks
Set sessionManager = CreateObject("QBFC15.QBSessionManager")
sessionManager.OpenConnection "", "QckbookSearch"
sessionManager.BeginSession "", 0 ' 0 = omDontCare
When I Try to Begin the Session from excel that error message show up
I appreciate the extra information, Laraque. I’ll ensure we effectively address the error messages you've encountered when integrating your VB routine in Excel with QuickBooks Desktop.
QuickBooks Desktop has specific permissions and access levels that can limit how external applications, such as your VB routine, interact with it. The error messages you are encountering occur because the application lacks the necessary access rights, which conflicts with the current operating mode of QuickBooks Desktop.
To get more specialized assistance, I recommend visiting the Intuit Developer Community. This forum is designed for developers and can provide valuable insights and guidance on connecting your application to QuickBooks Desktop.
Here’s how you can post your concern there:
Additionally, I’ve included these QuickBooks articles that can enhance your experience by outlining various functionalities and addressing common questions about connecting Excel and other applications to your QuickBooks Desktop data:
This thread remains open for any other questions or concerns regarding your integration with the program. Let’s work through them together for excellence in financial management.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here