>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
When I design the databases, I generally place the tables in one DBC and the views in another. Therefore, I can switch between having the tables as FoxPro tables and SQL Server (or anyother backend) without having to modify the code.
Just a suggestion.
Greg Reichert