>>After reading the VFP docs about free tables, it appears to me that if I have a dbc open, then if I use a table, its automatically put in the dbc.
>>
>>Here is my concern, I have a dbc open during my applicaiton, I open the actual dbf's and use them, close them etc. but there is this part of my application, where I think it would be wise to not use the dbc, and have each user have a free table on their own computer....Like private data. local data to that user only.
>>
>>so really my quesiton is I can use create table free command in code to create a free table. then if a dbc is open, and that free table is used.... does that free table get put in a part of the dbc. ? and if so, is there some way I can tell vfp not to add this table ever to the dbc. ?
>>
>>Thanks
>>Bob Lee
>
>Bob,
>Free tables or fox2x
tables are not autmatically put in a dbc. You can close-open them. There are few situations that would make them part of DBC like :
>add table...
>create table when a DBC is open
>Also fox2x tables would remain as is if you don't trigger structural changes like null value support, new data type addition.
>Cetin

Just don't forget to use FREE clause when you create your tables, and they would not pollute your database. We had this problem few times...