Knowledgebase: QODBC Online
[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 9 records full of "#Deleted", then a normal, valid record, then 4 more full of "#Deleted", then one more valid record. Total 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

(1 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).