>I have a view that I have added to my data environment. In my save code I check to see if a certain table is in use. If it is I append from it. The problem is it isn't in use but it thinks it is because its included in my view in the data environment. If I delete the view from the data environment it works properly but I do need to use it at some point on that form. Is there a way I can include it with my form? I have set the NoDataOnLoad property to .T.
>
>Tyler

Tyler,
If you open a view (no data or not), VFP opens the underlying table too. What do mean by "it isn't in use but it thinks it is"? Used() returns .T. because the table is open.

If you need under different circumstances, you open the table under a different alias in another work area. Use the USED() function on the new alias and not the table name/alias.

HTH.