>Have you not tried other ways since you started programming in VB other than the above approach? In VFP, there are many ways to access data but personally, the cleanest of them all and effective is the Data Environment: You can relate tables, drag and drop them, set filters, etc.
>

The VB and VFP DEs are a bit different. The overhead in opening native VFP tables is minimal especailly when compared to the tremendous flexibility and benefits you get by being able to associate a private DE with each form. You however must be more consertive when your DE has remote views - just as with the VB DE you need to keep your number of connections and size & number of recordsets to only what is needed. The equivalent of private DEs in VB is achieved (not with the DE but) by making recordset variables private to its module, form, etc. And just as in VFP you would make the Connection public to all recordsets (remote view) hitting the same data source.