In VFP 6, CLOSE DATABASES will close the currently open DBC and its tables. If no DBC is open, then free tables are closed.

Conversely, CLOSE TABLES ALL will close all tables (but not the DBC) of the currently open DBC. If no DBC is open, all free tables will be closed.

Whew! Got that?

- Gerry

>Hi Bill
>
>If you issue "Close Tables" only the tables for the selected database will close.
>
>Oscar
>
>
>
>
>>i don't want to close all tables only doea who belongs to a datebase can i still ues close tables

** Gerry White / Hagerstown, MD, USA --
** Developing since 1986 in Foxpro, VFP, Oracle, and Java.
** http://GerrysPlace.com