>No, it has more records, I tested this, it works in VFP environment, but doesn't in compiled version.
And NO errors?
No way.
Are you sure you didn't suppress errors with something like:
ON ERROR *
or have a code in the form Error event?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.