>Hi, Igor!
>
>>I need some ideas on how to create an application. This application will be >distributed to several clients. One client has data stored in MS Access, >another client - in native VFP 5.0 tables. What is the best approach to design >the application?
>
>The best way is full isolating front-end application from data source. This is a kind of well-known multi-tier approach. You provide class(es) that exclusively communicate with data source. You application knows only how to "talk" with that object (component), i.e. application is advised what method(with what parameters) must be called to get a cursor, what method must be called to modify specific data and so on. Deployment can be the following:
>
>Application instantiates the object oData
>oData connects to the database through ODBC or ADO
>Application calls method oData.GetCustomersList()
>oData calls appropriate stored procedure on the server on perform SQL passtrough
>oData pass received data to the application as VFP table, cursor or array (it can depend of data object location - using COM we can have it on remote computer)
>...
>
>I.e. if different clients prefer work with different server you showld have two different oData class with the same methods/properties (and something on server level), not two different applications. And supply your clients with appropriate oData classes.
>
>As for middle-tier implementation details I recommend you use ADO for MS SQL and native VFP code for VFP database. You can implement both components using VFP as out-of-process OLE-servers.
>
>It is very huge topic... If you have detailed questions - welcome.

Hi Dmitry,

Thank you for reply. I'll definitly use data class to access different data sources. The idea to use VFP ODBC driver from within VFP sounds very interesting. Yet I loose perfomance. Did you tried it?

Sincerely,