>Naomi,
>
>I did try the test code you specified and the records are recalled successfully in the newly created table, as expected. However, I just can't seem to get all the records to recall when working directly with this one problem table. No indexes are filtered.
>
>Jon
>
No unique indexes either? Sounds to me like some sort of a corruption. Try getting the records the same way as I said, zap the original, append from new one, play with the delete all / recall all - would you still have this problem?
If it's not broken, fix it until it is.
My Blog