Knowledgebase: Data & Table
[QODBC-ALL] Troubleshooting - MS Access displays "#Deleted" in every field
Posted by Jack - QODBC Support on 21 September 2016 11:36 AM

Troubleshooting - MS Access displays "#Deleted" in every field

Problem Description:

Using QuickBooks Accountant, QODBC, and MS Access Linked table.

Sometimes, e.g., at present, working with the InventoryAdjustment table, a table view or query returns the right number of records, but many of them have "#Deleted" in every field. On this occasion, which is typical, I have nine records full of "#Deleted," than a normal, valid record, then four more full of "#Deleted," then one more valid record. Total of 15 records, which is what QB shows me. I can't see anything significantly different from the ones which appear. 
 

Solution:

To resolve this, You need to relink your linked table in MS Access.

Refer: How to Re-Link QuickBooks Data in MS Access using QODBC

(3 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).