I'm still not clear, so I'll rephrase the way I understand. Your data is currently in VFP. When you move to the web, you want to move the data to SQL Server, but still use your VFP code for the business rules. Did I get that right?
If so, then yes, ODBC is the way to go.
>Craig. Thanks for your reply. Currently, I am on Fox data but I want to ODBC to SQL Server. Since I am using Fox 7, am I going to run into any troubles when I take my data to the web?
>
>Thanks, Randy
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer