>>>I've acquired a software project 9 months ago using VFP that accesses data using free tables as opposed to a database. Among the many clean-up activities we'd like to perform on this project is wrapping up all the free tables in a database and changing the many modules (exe's) of this project to use the database. Ideally, we'd like to change one exe at a time to use the database. Is it possible (and advised) to have one VFP-created exe access a set of free tables at the same time another VFP-created exe is accessing the same tables but through a database?
>>>
>>>Thanks,
>>>
>>>Valter
>>
>>Yes you can. What you can do is create a local view of every free table without adding the actual table to the DBC. Name each of the views exactly the same as the free table name. Once all the EXEs are in place, you should be able to remove the views and add the tables to the DBC without changing any code.
>>
>>Once you get the local views created, you can then create other parameterized and other more complex views based on your free-table local views.
>
>I'm doing something similar at the moment. All the views of the app were created outside the Project Manager, but are contained within database containers. I want to add everything into the PM. I also have the added issue that the tables need to remain free. I add the database to the PM, add the free table and then create the view with the same name. The problem comes up when I try to modify a previously existing view that was based on the free table (not part of the PM before); it loses all the settings. Like it was a brand new view waiting for me to select the fields to use. I would really like to keep the existing view intact and not have to redefine it if possible. Any ideas? Thanks!
>

Renoir,

PMFJI, but Eric Moore's e-View utility in the files section may help.

Doug