>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.
Mark McCasland
Midlothian, TX USA