And then you lose a lot of what makes VFP great. You're forced to use a very old ODBC driver. No reason to not write the app to use local views for VFP and remote views for SQL Server. It's a simple property change...and something you can change via configuration.
>I originally considered doing it that way. Problem with using the local views is that VFP still opens the tables with local views - not with remote views - which is why I use the remote views.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer