Troubleshooting - How to fix duplicate records in the QODBC table.

Problem Description:

I want to cancel my QODBC Driver for QuickBooks Desktop monthly subscription.

How do I cancel the subscription to the QODBC Driver for QuickBooks Desktop?

Solution:

Start QuickBooks and log in to the QuickBooks company file as QuickBooks user "Admin".

Connect to QuickBooks Data using the QODBC 32-bit Test Tool.

Execute the following SQL statement.

sp_optimizefullsync TableName

example

sp_optimizefullsync Customer
or

sp_optimizefullsync Vendor

or

sp_optimizefullsync Invoice

Tags: QuickBooks Desktop, QBD, Desktop Subscription QODBC Desktop, Cancel subscription

Start QuickBooks and log in to the QuickBooks company file as QuickBooks user "Admin".

Connect to QuickBooks Data using the QODBC 32-bit Test Tool.

Execute the following SQL statement.

sp_optimizefullsync TableName

example

sp_optimizefullsync Customer

or

sp_optimizefullsync Vendor

or

sp_optimizefullsync Invoice