Link SQL 2005 tables with MS Access ODBC

[Guest]

I am trying to Link SQL 2005 tables with MS Access ODBC. I setup an ODBC
System DSN to the SQL 2005 database. The test says the connection is working.
When I use the link table feature, and select Files of type (ODBC
Databases()) the link form closes. I get no error messages.

SQL 2005 resides on the same computer as MS Access 2003.

Any suggestions?

 

[Sylvain Lafontaine]

Most likely this is the Norton Antivirus 2006 Office Plug-in (or another
anti-virus) that is blocking the dialog window. De-activate the Office
plug-in when you want to create an ODBC linked table (you can reenable it
later).

 

[Guest]

I have 2007 norton internet security and I cannot find that optional plug in.
I know if I turn off NAV then it works.

 

[Sylvain Lafontaine]

Ah, for NAV 2007, it's named the Turn on scanning for Microsoft Office
Documents:
http://support.microsoft.com/kb/329820

This article also says that running the Live Update might correct the
problem but I cannot tell you is this is any good because I don't have NAV
2007.