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