Using the trial so far. I was able to populate 6 of 7 different QB companies to Access successfully. For one company, I get the following error every time:
Failed: The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again. vbcrlf & (Please reconnect to your database server and try again.):-2147467259
This includes after a Rebuild. QB version (Manu. & Wholesale) 16.0 R11P
there is a bug on QuickBooks that is causing that issue. We are working on the way around. In the mean time you can remove the primary key attribute and the the index (see attached)
I got the same error message when I created Access database. Which table should I remove the primary key attribute and the index in Access?
You must be logged in to reply to this topic.