Linked Table Manager does not display linked tables

[Tim Heames]

We have just installed Microsoft Office 2003 on top of
Office 2002. I pulled up an Access routine and went to
relink my linked tables to another set of the same tables
on another server. However, when I called up the linked
table manager, no tables were displayed even though they
are clearly shown over in the tables view of the database.

When we installed Office, all features of Access were
installed (i.e., set to run from my computer). Any ideas
on what is wrong?

 

[Marty]

Simply because you can see linked tables in the Tables
section of the database doesn't mean it's "there". You
can sever the link and all the table will still be there
even if in name only. Since the tables are linked, in
other words not really there, delete all the linked
tables, ONLY the LINKED tables, and re-establish the
link. Of course BACKUP BACKUP BACKUP the databse before
you do this. I'm sure your problem will be solved.
Although, I must say it is puzzling why it doesn't see
the link now.

Marty

 

[Joan Wild]

Re-register accwiz.dll (the one located in the same folder where Access 2003
is installed)

Regsvr32 "path\ACCWIZ.DLL"