Linked Query in MS Access 2007 to SQL database - ODBC error - How do I see the linking details?

Question

I am converting an old Access 2003 database to 2007. It has a query linking to a SQL database. How do I look at the link, e.g., whether it using a DSN, etc.?

The query has the globe to the left of it indicating it is linked. When I try to Open it, it says "ODBC - connection to '(a database name)' failed."

I have searched and seen many posts on Access tables linking to another database, but none of a query linking to another database.

Answer 1

You can find the connect string of a table by typing this in the Immediate Windows in the VBE:

  ?CurrentDB.TableDefs("TableToCheck").Connect

That should get you started...