FoxPro2.6

I'll start by saying that I have been programming for years but have never done the database thing, so all this DAO ADO SQL stuff means little to me but here goes. I writing some programs that rely on very large FoxPro2.6 data files, the problem that I am getting is that when I open the files using a Data object set as a Dynaset the first time I try to query the file it takes an absolute age to populate the file. It is also very slow when moving through the file. I assume that it is something to do with Jet sitting in the middle, is there a better way.
P.S. I cannot convert the file to Access or something because it is a live file being used across a network.

You can use DAO, ADO and RDO to connect directly to your FoxPro data files.

You may still get some performance issues.

If need an example for this, just re-post

I'd love an example.

I have been looking at the help files on ADO but they seem to go round in circles and it's doing my head in.

Until now I have been using the data1 object, which works, but there must be a better way.

If I move to end record, it takes ages the first time, but after that it seem fairly quick.

If I use ADO can I use the FoxPro indexes that already exist within the file? as I can't workout how to use them with the current method.

I really would appreciate an idiots guide to this, as I have produced lots of good code and it's just the database access that is letting me down.