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