OpenSync

Home Forums OpenSync Populate Fails for one Company

This topic contains 2 replies, has 3 voices, and was last updated by  nmurata 11 months ago.

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #63061

    joe.travassos
    Participant

    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

    Any ideas?

    #63068

    Yudel Rosales
    Keymaster

    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)

    Attachments:
    You must be logged in to view attached files.
    #63567

    nmurata
    Participant

    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?

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.