I thought about that and if that is the only solution I may have to do it that way. This particular query has a large number of joins and I was wanting to avoid re-creating them. What I did try to do is to view the query in SQL mode, then cut and paste that into a new query window in SQL mode. Unfortuneately that did not work.

I have an ODBC to several tables in an Oracle 10g installation. I created an Access 2003 query using several of the tables from that ODBC. When I created it, it worked as expected and returned the necessary info. Due to another application that uses the Oracle TNS names entry that the ODBC was using, the Entry in TNS Names had to be editied. Now the original query will not run, the error is ODBC connect error. If I place an additional entry...