error with linked tables manager

[Wendy G]

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]

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

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

 

[Joan Wild]

I'm not sure what to suggest. I just tested on my machine, had an empty
linked table mgr list. I did a search for
regsvr32.exe: accwiz.dll

This returned three accwiz.dll files (I have three versions on this
machine). I dragged the correct one onto regsvr32.exe, and got a message
that it registered successfully.

I then reopened Access and the LTM showed the linked table.

 

[wg]

I tried the re-registration process again, this time by drag-and-drop, and
again the message reported "successful" -- but when I reopened Access still
nothing in the LTM window.

I also searched my system for regsvr32.exe and found two files. One is in
the C:\Windows\system32 directory (this is the one I re-registered the
accwiz.dll to) , the second is in a statistics program directory ( C:\program
files\SPSS\ ).

Could this second regsvr32.exe file have anything to do with the LTM problem?

Anymore suggestions?

Thanks,
wg

 

[Joan Wild]

The one the windows system folder is what I used. The other one shouldn't
matter.

Ummm...you do have linked tables in the database you're opening, right?

 

[wg]

Yes, I have 5-6 linked tables in the database. All tables can be opened and
the data shows up in reports OK. So, this is not a "crisis" issue of being
able to see/use the linked data. But it is disturbing that it might
turn into a bigger problem--and inconvenient to manually re-link the tables.

wg

 

[Joan Wild]

Sorry wg, I don't know what else to suggest.

They changed the linked table manager in 2003 (gave it some scroll bars so
you can see the full path). That change affected accwiz.dll.

You are seeing the problem because the old version is the one that's
registered and 2003 isn't displaying it correctly.

You could maybe try Detect and Repair in the Help menu.

 

[wg]

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?

wg

 

[Joan Wild]

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.aspx?scid=kb;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.

 

[menlos]

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

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

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

-
menlo

 

[Frog]

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

 

[Joan Wild]

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

Answered in externaldata.

 

[Frog]

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.aspx?scid=kb;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]

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

 

[Frog]

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.