>Hi Barbara
>
>Thanks for responding.
>
>>So, if you USE the view, the source tables are opened. If you then close those source tables, but later REQUERY() the view or call TABLEUPDATE(), the tables will be opened again.
>
>I was thinking in terms of open tables being corrupted, so I guess after each requery we can safetly close tables?
You could. VFP will open them when it needs them, but opening tables is a relatively slow process. If you're concerned about corruption, instead of closing the tables, you might want to add a FLUSH command after your TABLEUPDATE(), and if you have any control over the server, make sure write caching is turned off.