G
Guest
Hello
I have been wrestling with a problem for a few days now and just can't figure it out. I am using Access 2002 Project connected to a Remote SQL Server. I have another database that is a regular .mdb
Problem
How do I join a table from an .mdb database and a SQL database to produce a recordset? I can access the individual tables using connection string and recordset, but if I wanted to use some kind of INNER JOIN statement on two tables that are in different databases and bind the single SQL string to a recordset, I come to a blank. I don't want to create temporary tables and such. Just join two tables that are in different databases in a single sql statement
Thanks
Ty
I have been wrestling with a problem for a few days now and just can't figure it out. I am using Access 2002 Project connected to a Remote SQL Server. I have another database that is a regular .mdb
Problem
How do I join a table from an .mdb database and a SQL database to produce a recordset? I can access the individual tables using connection string and recordset, but if I wanted to use some kind of INNER JOIN statement on two tables that are in different databases and bind the single SQL string to a recordset, I come to a blank. I don't want to create temporary tables and such. Just join two tables that are in different databases in a single sql statement
Thanks
Ty