Error #80040422 is saying, "This application requires Single User file access mode and there is already another application sharing data with this QuickBooks company data file." This could even be caused by your application having a active connection already.
A good example is when I use MS Access and link a QODBC table and then run a QODBC pass-though query on another table (that's not linked) I will get the message even through I am just running QuickBooks on my Windows XP Notebook. I get the error because at that point of time there are two concurrent connections and my complany file is in Single User mode.
The answer is that the Company file should be by default in multi-user mode always unless you are deleting records.
You can also specify the OpenMode setting in your connection string. See: How do I build a connection string with all the available QODBC parameters? for more.
As far as QReportGrabber support is concerned, please contact AccountiGrate directly on 888-302-8928 or sales@accountigrate.com for further support as the developer is now selling and supporting the product directly. |