By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,956 Members | 1,657 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,956 IT Pros & Developers. It's quick & easy.

Create 1 recordset from tables in 2 different locations for report recordsource

P: 3
I am trying to avoid linking external tables using DSN ODBC's on clients. I have 2 foxpro tables in 2 different locations that I need to pull data from. I need to code the connections to them using ??ADO/oledb/ODBC ?? and create a joined recordset and use that recordset as the recordsource for a report. I can do it using 2 different ODBCs and linking to the tables but this means we have to create the ODBCs on every client that wants to run the report.
Table1 - c:\dir1\
Table2 - c:\dir2\

Select * from table1, table2 where table1.name = table2.name.
Oct 26 '06 #1
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,342
I've never used it myself but I think there is an option to define a file based DSN which might better suit your needs.

As for your SQL, would not an INNER JOIN between the two tables work more effectively (albeit giving identical results)?
Oct 26 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.