I have created synonyms on tables in SQL Server 2005. Does anyone know of a way to make those synonyms available through ODBC for use in MS Access?
I have installed the latest SQL Server Native Client development pack; but the synonyms do not show up in the list of tables when linking via ODBC.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!