ODBC problems when joining Access table to linked
I use a DSN to open a connection to an Access database. I then execute a SQL statement that joins a table in the Access database to a linked table. This linked table is via DSN to MS SQL Server. I receive an 'ODBC-connection failed' error on the second DSN when executing the SQL statement.I can properly select from either DSN by themselves, and I can execute the orginal statement if the SQL table has been imported instead of linked via DSN.I have seen references to this problem, but am in need of a resolution.TIA,Jay
Last edited by Jay; 04-16-2011 at 01:24 AM.