Hi Terry

>I am working on a project. There are two modules. One (production module) that will connect to VFP native tables (through intranet) and a client module that could connect to SQL (and/or VFP Tables).

Checl out the white paper (and samples) on our website entitled Class-Based Data Management (http://www.tightlinecomputers.com/Downloads.htm). It may give you some alternative ideas on how to do this. (Just click the link to download it)