Troubleshooting - "Cannot update table ItemInventory Error 10004"
I am trying to run an update on the Name field in ItemInventory. I've checked to see if it's updateable and it is.
I get "Cannot update table ItemInventory Error 10004" and then sometimes a window pops up after clicking OK saying there is not enough memory to complete this task or similar. I was unable to get a screenshot of the error. I run the query with nothing else open overnight on a computer with 16GB of RAM. Memory should not be an issue. I need to be able to update part numbers in batch because there are over 30,000 parts. Can't do it one at a time.
Please put a limit on your update query & try again. Instead of updating all records at a time. Please try to update records in a small group/part.
QODBC is an ODBC driver. The QuickBooks interface SDK, which uses XML, is not the speediest file system available, but it does the job. The QODBC driver works with all front-end applications which can access ODBC, some of which are faster than others.
Please keep in mind that QODBC is not a database tool, but rather a translation tool. QuickBooks is a non-normalized flat file system which has no indexes available to us and will not perform like SQL Server or dBase files. Every transaction you request must be translated and communicated to QuickBooks via large complicated XML transactions.
The QuickBooks application layer needs to process those XML requests. The larger the number of Records, the lengthier the XML request, therefore QuickBooks may take more time and memory to process longer requests.
QODBC sends the request to QuickBooks (via QBSDK) and QuickBooks will process the request(request is in XML format), if records are more in numbers than QuickBooks may throw "Out Of Memory" error.