I don't know about you or others, but I avoid DE. I only use it during creating the form(s) to use the droplist, but that's about it. So, my suggestion is (as this is what I do) is open ALL tables in SHARED (just SET EXCLUSIVE in the beginning of a main.prg is enough) and (also in beginning of main.prg) CURSORSETPROP("Buffering",3,0). Don't "just do it" until you know about it...

Chuck

>I noticed that when you have a form with tables added to it's Data Environment and set to automatically open
>and close with the form, and then through code you temporarily close one of the tables and reopen it, when the form
>is finally closed the file that was manually closed and opened doesn't seem to be controlled by the form anymore.
>Am I not to put tables in the Data Environment for a form that will be closed and reopened manually in code ?