>You could use the free table from two different databases, for instance, with views. But by keeping the table free, you lose some advantages, especially triggers (and therefore, referential integrity).
>
>>Hi all,
>>
>>I have an FPW/VFP6 app where the data is in free tables. I would like to begin modernizing the app to VFP8 (VFP9 after it is gold), one departmental module at a time.
>>
>>My question is, can a free table in use by another application also be part of a DBC? Or do I need to look at CursorAdapters or Views?
>>
>>Once the interface is upgraded for all departments and operations the data will move to MySQL on a Linux server.
>>
>>TIA
Hello Hilmar,
Until the conversion is complete the tables have to remain free. But with views, a lot of the work is done when I start using MyODBC to connect to the data.
Thanks
Opportunity is missed by most people beacuse it is dressed in overalls, and looks like work --- Thomas Edison