Thank you for reply, not been here for a while.
I'm going for ODBC of VFP data to increase speed across network for multi-user. This will also allow me to write a data layer in VB. Gradually moving application away from VFP to ASP/VB/MSDE with option of VFP, SQL, Access, Paradox or any other back end.
>Hello,
>
>i would not access FoxPro data over ODBC .. it's just unneeded overhead.
>
>you can use local/remote views to seperate data access - this approach limits you to use ODBC based datasources beside FoxPro
>
>or seperate the data layer into CursorAdapters with DataSourceType either set to "Native" (for FoxPro) or "ODBC" / "ADO" to access SQL Servers ..
>
>Regards
>
>Christian