error with linked tables manager

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

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

As another person (another thread) mentioned, the re-registering step did not
work for me. I too have Access 2000 and 2003 installed on the same machine.
This results in 2 Accwiz.dll files, but they are in different folders. I
attempted to re-register the Access 2003 file using the following command:

regsvr32.exe "C:\Program Files\Microsoft Office\OFFICE11\Accwiz.dll"

I think the subsequent message reported the operation was successful, but it
was so quick I could not be certain.

Any further advice?

wg

"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

I re-registered the ACCWIZ.DLL file as suggested. But, like another post
mentioned, it did not work. I have Access 2003 and 2000 installed in the
same machine and this results in two ACCWIZ.DLL files (with two different
paths). I re-registered the file associated with Access 2003 using the
followiong command.

regsvr32.exe "C:\Program Files\Microsoft Office\OFFICE11\Accwiz.dll"

The subsequent message reported the operation was successful. Then I closed
Access and re-opened it, but still no table links present.

Any other suggestions?

wg
~~~~~~~~~~
"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

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 wrote:
I re-registered the ACCWIZ.DLL file as suggested. But, like another
post mentioned, it did not work. I have Access 2003 and 2000
installed in the same machine and this results in two ACCWIZ.DLL
files (with two different paths). I re-registered the file
associated with Access 2003 using the followiong command.

regsvr32.exe "C:\Program Files\Microsoft
Office\OFFICE11\Accwiz.dll"

The subsequent message reported the operation was successful. Then I
closed Access and re-opened it, but still no table links present.

Any other suggestions?

wg
~~~~~~~~~~
"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

--
Joan Wild
Microsoft Access MVP

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" wrote:

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 wrote:
I re-registered the ACCWIZ.DLL file as suggested. But, like another
post mentioned, it did not work. I have Access 2003 and 2000
installed in the same machine and this results in two ACCWIZ.DLL
files (with two different paths). I re-registered the file
associated with Access 2003 using the followiong command.

regsvr32.exe "C:\Program Files\Microsoft
Office\OFFICE11\Accwiz.dll"

The subsequent message reported the operation was successful. Then I
closed Access and re-opened it, but still no table links present.

Any other suggestions?

wg
~~~~~~~~~~
"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

--
Joan Wild
Microsoft Access MVP

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?

--
Joan Wild
Microsoft Access MVP

wg wrote:
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

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" wrote:

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?

--
Joan Wild
Microsoft Access MVP

wg wrote:
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

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.

--
Joan Wild
Microsoft Access MVP

wg wrote:
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" wrote:

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?

--
Joan Wild
Microsoft Access MVP

wg wrote:
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
Microsoft Access MVP

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" wrote:

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.

--
Joan Wild
Microsoft Access MVP

wg wrote:
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" wrote:

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?

--
Joan Wild
Microsoft Access MVP

wg wrote:
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
Microsoft Access MVP