>I am moving from FPW26 to Visual FoxPro 6. I am considering making a database as opposed to using free tables, but am concerned that in doing so I will end up with a single huge file (like Access!) instead of my hundreds of much more easily handled and controlled free tables. Will I indeed end up with a 100MB database file, or will I have a small database file which simply communicates with the 100MB of data? Also, will I be able to open up a single table within a database AS IF it it were a free table once I change? THANKS SO MUCH.

David;

The dbc and related files are small and independent of tables, as tables are independent of the dbc. They are associated with each other. If you change a table or view you send the updated table and dbc (dct and dbx) to the client or whatever and not all the tables. It is not “one big file” like Access for example.

One of my clients required a new field in a table so I modified the one table and the dbc/dct/dcx files and sent him the work by e-mail. No need to send all 50 tables just the items required.

Tom