>We are using ColdFusion to query VFP tables and find that when
>a Foxpro table is open on the lan server the ColdFusion query executes really slowly, up 30-50 times slower than when the file is not open.
>The problem therefore is that when our in-house application is running the web site is really slow.
>
>Can somebody please help !
I third the recommendation about west wind. used it about a year and like it an awful lot. Particularly if you are first FoxPro or Visual FoxPro programmer. It really does help to be good with HTML though since there is no visual design interface (with the caveat that you can write VFP forms and convert them to westwind)

As far as your ODBC problem are the tables open from the server or from some other client machine? That is is VFP running on the server?

Do you have the latest VFP ODBC driver?