Hi All,

I'm not sure that this is the appropriate category to post this, but, here goes.

I've managed to create an ADODB recordset from a single VFP7 table that currently sits in a particular folder. I'm using a connection string with Provider set to VFPOLEDB and the Data Source points to the folder where the table exists.

I now want to create a different recordset using Open(SQL select...) where the SQL select takes data from two VFP tables. My problem is that the tables are located in separate folders and I don't know how or if its even possible to make this work. As far as I can see, the Data Source only points to one folder. How do I get it to look into another folder where the second VFP table is located?

Anyone know if this can be done?

TIA

Regards,

Mike