>Hello !
>
>As my application got bigger, sometimes it "gifts" me with some corruption data, so I'm thinking on moving to a "real" database, such as MSDE.
>
>But I Know some people use the ODBC to control the data from DBCs, using remote views.
>Is it worth a try ? What would be the advantages / disadvantages ?
>
>What about the speed to access the data ?
>
>Thanks in antecipation,
>
>Cesar
I've done this. The biggest advantage is that if you make your VFP tables properly (make them compatible with SQL Server tables - for example use DATETIME fields, and not Date fields) - then when you want to move from VFP backend, to SQL Server backend, all you have to do is change the connection string your remote views are using.
I did not have any problems with speed to access the data.
ICQ 10556 (ya), 254117