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