>I do have the table open multiple times using AGAIN. Wonder if there's a bug in VFP9 with using the same table multiple times with different ALIASES? Speaking of which, I HAVE seen some weird behavior relating to cached data on tables that are open multiple times.
I'd look real hard at the AGAIN situation. I rarely use it myself, I usually SELECT into a separate cursor and use that instead (e.g. for lookups).
If you're concerned about data caching you could experiment with FLUSH FORCE (new to VFP9).
It might also be worth testing with any antivirus temporarily disabled (especially real-time scanner).
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up