Can't Add a linked table to SQL Server 2005 with Access 2003

[bonkers1963]

Hi,

I have an Access 2003 front end that contains a number of linked tables on
SQL Server 2005 SE. I recreated the application on a second network for
testing and was able to use the Linked Table Manager to refresh the database
connections. The problem is when I try and add another linked table. I
select Link Tables from the menu and then when I select 'ODBC Databases()'
from the 'Files of Type' list box, the Link window closes right away.



Any suggestions?

 

[Granny Spitz via AccessMonster.com]

The problem is when I try and add another linked table. I
select Link Tables from the menu and then when I select 'ODBC Databases()'
from the 'Files of Type' list box, the Link window closes right away.

Do you have Norton Antivirus installed? If yes, disable the Norton Office
plugin temporarily while you link the tables, then enable it again.