Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
Click Here
|
Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
|
Lots of records appear with #Deleted in every field |
Author |
Message |
|
Posted : 2007-05-15 02:21:58 |
Using QuickBooks Accountant 2006 UK, QODBC Build 207 and Access 2003.
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 about the ones which appear, and I've tried optimizing. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-05-16 23:57:33 |
You need to udpate QODBC to v7.00.00.214 (or later) see: How can I get the latest version of QODBC?, from there, re-optimize your tables then try unlinking and relinking the tables. When a change is made to a QODBC table structure, MS Access still uses the structure that it originally saw when it was first linked and therefore doesn't display certain tables correctly. |
|
|
|
|