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.