Linked Table Manager Empty ...Again!

[Hugh Mulholland]

On a new notebook I installed Access 2003 (and the rest of Office Pro).
Linked Table Manager worked fine. Had to install Access XP on same machine
(different drive) and Linked Table Manager problem appeared. Having had the
problem on earlier laptop, I found kb article and registered accwiz.dll from
2003 install. No help! Then I registered the xp .dll and the 2003 .dll
again. Still empty!

One other thing I did about this time is install Windows XP SP2, is anyone
else reporting new Linked Table Manager problems after installing SP2?

 

[Jeff Conrad]

Hi Hugh,

I've seen posts about this as well. Here is some information from a Microsoft employee which may
help:
I have seen this issue when re-registering Accwiz.dll does not work you will
need to manually change the below registry key and make sure it's pointing
to the correct file

C:\Program Files\Microsoft Office\OFFICE11\ACCWIZ.DLL

HKey_Classes_Root\TypeLib\{5B87B6F0-17C8-11D0-AD41-00A0C90DC8D9}\8.0\0\win32
\(Default)

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.

Regards,

Eric Butts
Microsoft Access Support
Hope that solves the problem for you,

 

[Hugh Mulholland]

Jeff,

That worked, but I noticed there are 2 registry entries, one for
Access 2002 (which is 8.0\0\win32) and another for Access 2003
(8.1\0\win32). Now both are set to the Access 2003 accwiz.dll and it
seems to work for both. Will this possibly cause me trouble sometime,
are there differences in the 2 dll's? Thanks.

 

[Jeff Conrad]

Hi Hugh,

Glad the problem seems to be fixed now.
To be honest I'm not sure if the two registry entries will cause problems.
I have not dealt with this situation personally (yet).

I would just see how things go for a while.
If everything seems fine I would just be happy and not touch anything.

If you start to have problems by all means post back into a new thread and maybe someone can give
some further advice.

Another alternative to the Linked Table Manager is to do all of this re-linking in code:
http://www.mvps.org/access/tables/tbl0009.htm

Good luck with your project,