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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
bonkers1963 said:
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.
Click to expand...

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