Virusim,

>> Just like to know in detail, if I had a few DBC with some big dbf file inside it, if I open the DBC(database file), all the dbf file
inside it will automatically open. right ? <<

No. But the opposite is true, if you open a table, the DBC is opened automatically.

>> However, if my dbf is big in size, will vfp 5 load all the data into memory or just open
the dbf file only. <<

VFP does not load the table into memory. Opening large files will not cause an "insufficient memory" error.

>> Will using nodataonload in the DBC help ? <<

Not relevant. I myself use NoDataOnLoad for parameterized views, when I do not want the entire table to come over the wire.