I saw this briefly mentioned in a a blog and posted a comment there, but I'm also posting it here as a request for help.
I've got an Access user who needs to create a dynamic link to one of my SQL Server tables. He needs to link to a synonym rather than a fully-qualified table name.
I need to keep the synonym functionality. Is there a way to force it to show up when you choose to "External Data/Import More/ODBC Database/Link to the data source ..." Currently, it shows only tables and I'd like to see synonyms in the table select view.
Hopefully this make sense.