error with linked tables manager

wg wrote:
I tried the detect and repair, still no linked tables showing. I
wonder if it would help if I uninstalled, then reinstalled Access
2000 or 2003, or both. If so, what order should I do it?

When you uninstall them, ensure you also run the eraser2k utility from
http://support.microsoft.com/default...b;en-us;239938

In addition, check on your 2000 cd for a cleanup utility called OffClean (I
think it's in the valupak folder).

You may find similar utilities for 2003.

Then reinstall in version order, ensuring you choose to install 2003 in a
separate folder.

--
Joan Wild
Microsoft Access MVP

I had the exact same problem and your solution worked for me. Thanks so
much.



Joan Wild wrote:
*Re-register accwiz.dll (the one located in the same folder where
Access 2003
is installed)

Start, Run and then
Regsvr32 "path\ACCWIZ.DLL"

Wendy G wrote:
Hello,
I have a 2003 database converted from Access 2000.
Several tables are linked from an Excel file. None of the
linked tables appear in the Linked Tables Manager, even
after I manually established fresh links. After
resetting the links, the following error message appeared:
----
Method 'List' of objects 'IFieldListWnd' failed.
----

Any suggestions as to having the linked tables manager
function properly? The linked tables appear to be OK,
just not the linked table manager.

Thanks,
Wendy

--
Joan Wild
Microsoft Access MVP *



--
menlos
------------------------------------------------------------------------
Posted via http://www.mcse.ms
------------------------------------------------------------------------
View this thread: http://www.mcse.ms/message939741.html

I tried all the the "solution" several times and it did not work for me.

"menlos" wrote:


I had the exact same problem and your solution worked for me. Thanks so
much.



Joan Wild wrote:
*Re-register accwiz.dll (the one located in the same folder where
Access 2003
is installed)

Start, Run and then
Regsvr32 "path\ACCWIZ.DLL"

Wendy G wrote:
Hello,
I have a 2003 database converted from Access 2000.
Several tables are linked from an Excel file. None of the
linked tables appear in the Linked Tables Manager, even
after I manually established fresh links. After
resetting the links, the following error message appeared:
----
Method 'List' of objects 'IFieldListWnd' failed.
----

Any suggestions as to having the linked tables manager
function properly? The linked tables appear to be OK,
just not the linked table manager.

Thanks,
Wendy

--
Joan Wild
Microsoft Access MVP *



--
menlos
------------------------------------------------------------------------
Posted via http://www.mcse.ms
------------------------------------------------------------------------
View this thread: http://www.mcse.ms/message939741.html

Frog wrote:
I tried all the the "solution" several times and it did not work for
me.

Answered in externaldata.

--
Joan Wild
Microsoft Access MVP

What does "Answered in externaldata" mean?

When I run my program on Access 2000 the Linked Table Manager correctly
shows 19 linked tables. When I run Access 2003 the linked Table Manager is
empty. I have tried the regsvr32.exe "C:\Program Files\Microsoft
Office\OFFICE11\Accwiz.dll" several times and I have made sure that it is the
correct version of Accwiz.dll.

Although the install instructions indicate that both versions can co-exist
on the same machine, I wonder if this may be the cause of the problem. I
found solution,
http://support.microsoft.com/default...b;en-us;239938 , for removing
all of Access 2000 from a computer but it is not recommended for Windows XP.
I am hesitant to remove Access 2000 because I am unsure about the reliability
of Access 2003. The current problem certainly weighs on my fears.

"Joan Wild" wrote:

Frog wrote:
I tried all the the "solution" several times and it did not work for
me.

Answered in externaldata.

--
Joan Wild
Microsoft Access MVP

Frog wrote:
What does "Answered in externaldata" mean?

Meaning that you also asked this question in the external data newsgroup.
You shouldn't post the same question to different groups by multiposting.
My answer there was..

If reregistering the dll doesn't work, then change the following registry
key
HKey_Classes_Root\TypeLib\{5B87B6F0-17C8-11D0-AD41-00A0C90DC8D9}\8.0\0\win32
\(Default)

It needs to have the correct path to
C:\Program Files\Microsoft Office\OFFICE11\ACCWIZ.DLL

--
Joan Wild
Microsoft Access MVP

The registry change did the trick.

This is the first time I have used this forum, I was not aware that I had
also posted the question to another newsgroup. I will try to restrict my
postings to the absolute minimum. Thanks for the help.


"Joan Wild" wrote:

Frog wrote:
What does "Answered in externaldata" mean?

Meaning that you also asked this question in the external data newsgroup.
You shouldn't post the same question to different groups by multiposting.
My answer there was..

If reregistering the dll doesn't work, then change the following registry
key
HKey_Classes_Root\TypeLib\{5B87B6F0-17C8-11D0-AD41-00A0C90DC8D9}\8.0\0\win32
\(Default)

It needs to have the correct path to
C:\Program Files\Microsoft Office\OFFICE11\ACCWIZ.DLL

--
Joan Wild
Microsoft Access MVP