I do not see any particular problem, give it a try. In fact, after reviewing my notes, I am not sure you cannot use alter table either. I will try it with some old FP2.5 stuff I got on my system.

Glenn

>Now that sounds like what I am looking for. May I use an exisiting dbc in my vfp project that contains many tables and views and just add views of the free fpw2.6 tables. I use sdt to maintain my dbc.
>
>Neil
>
>
>>Of course you can use/read/write to FP2.6 tables from VFP. It is safe and consistant with backward compatability. SQL views are only maintaiuned in a Database Container and therefore the tables cannot be contained in the DBC. It is possible to create a DataBase with nothing but views. These views could be based upon free tables (FP2.6). I did this once 5 years ago while integrating VFP with FP2.5.
>>
>>On caveat however is DO NOT alter table with VFP on a FP2.6 table. AFAIK this will modify the header to make the table unusable by FP2.x
>>
>>Glenn
>>
>>>Hi,
>>>
>>>I have a legacy FPW 2.6 application that maintains 19 tables. Is there a way to have a multi threaded vfp 7 dll read and write the fpw tables while the tables are also being read and write by the fpw 2.6 exe. What tricks can I perform that allows me to create views of the fpw2.6 tables.
>>>
>>>Neil