>Hey John
>My problem is that all the data currently out there is being accessed by 2.5 program. The new progam I am writing is a data entry program to bring them into year 2000 compliance and I need to use the current databases. I want to write directly to the tables and not ODBC as it has to be distributed to 200 locations. Any other ideas.
>
>Gaylen
Gaylen,
I am with George and would access the tables with the ODBC driver. I am doing this daily and performance is satisfactory. By doing so your application new data (in VFP tables) and the old data can be stored in just any place and you won't have to store a fixed path to your 2.6, the ODBC settings will have it. This would allow you to build remote views on your 2.6 data and work with it as if it were VFP data.
On the other hand, you don't have to worry about the codepage thing. Your best bet should be to tag all you 2.5/2.6 tables with an appropriate codepage (probably 437 in your case). Then VFP 6 will never worry you again with the code page dialog regardless of its current setting.
José