Unfortunately it's not a database corruption issue. I've tested with a brand new data set (created with gendbc) and same thing.
Somehow I'm manifesting a bug in VFP and I still think it's related to having a table opened multiple times in VFP9. I would bet $100 if I compile this app into a VFP8 EXE the problem would go away. Any takers? :-)
I've figured out a temporary workaround fix (for the time being) and now I'm trying to isolate the exact code that is causing the problem. Unfortunately this is one of those errors than can not be duplicated in development environment, only in the compiled .exe which means isolating the problem is time consuming to say the least. Change a piece of code, compile, test. Change code, compile, test.
As always, thanks for your help Sergey.
Brandon Harker
Sebae Data Solutions