>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,

Hi Mike,

I don't know if it would work but you can try to specify full name (including path) for the other table.