I do this all the time. I use a seperate DBC for the remote views. The trick is to make all of your VFP tables and MsSQL tables the same. (In other words, don't use field types in one that are not in the other, such as Date in VFP - use DateTime.) If you do this, then the only thing you have to do to switch from one to the other is change the connection string in the DBC with the remote views.
>Hi,
>
>I have been considering mixing a lan product (dbc, foxpro tables) and MsSQL server in the code.. I wonder if anyone has any suggestions - like "are you nuts" or " I did it and it's easy". I was thinking I could use the same DBC and just add the remote_views. At first this sounded OK but then I thought I could just create a second DBC just for the remote_views. The code that would use the MsSQL will (90%) of the time only read the fox tables. Any help or suggestions?
>
>Thanks in Advance
>
>John
ICQ 10556 (ya), 254117