Norton Antivirus strikes again - ODBC to SQL Server 2005
From a recent newgroup posting
> I'm trying to link an Access 2003 project to a SQL 2005 database on a
> network server. Everything seems to go okay until I select ODBC as the type
> of source I want to link to and them nothing happens. If I select any of
> the other types of files such as Excel I get the appriiate dialog box. What
> is going on??? I'm running VISTA 64 Bit on the wokstation and Windows 2003
> Server on the database server.
>
I had the same problem - felt a bit dishearted when I saw there was no
response on your question. But - I found the solution!
Van T. Dinh (MVP (Access) wrote in one of the other groups:
"If you use Norton AntiVirus, try disabling the Office Plug-in. You'll
find the Office Plug-in under 'Miscellaneous' in the Norton AntiVirus
options."
Update 2007-06-21. Fellow MVP Jens Schilling mentioned this problem back in 2006-10-03 in this Google posting titled Connecting to data sources