Thanks Mike...That was it. I thought that the sql statement accessed the latest data. That's why we were using the select * from database!filename.
I guess FoxPro was just optimizing the search so it would not have to Requery the table and cause network traffic.
I guess we really do learn something new everday....
Thanks again
Shawn