>I'm being ask to help someone with a problem and I'm looking for ideas, insights and workaround :-)
>
>An application is built with VB as frontend and connects through ADO to a VFP backend.
>
>The problem is that it is very slow (up to 20 seconds in some cases)when updating the database.
>
>I have work with VFP and with VB but never with this kind of setup and, before I diving in, I would welcome your comments.
>
>Some solutions come to mind, and would like your input, or other solutions :)
>1. use of DataClass (I thought this would apply to VB/VFP apps)
>2. migrate the backend to SQLServer (although VFP backend is fast)
>3. migrate the frontend to VFP
>
>
>TIA.
Try moving the back-end to Jet (Access) and see if it's any faster.
-JT
Jeff Trockman, MCP