If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
error with linked tables manager
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 |
#3
|
|||
|
|||
error with linked tables manager
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 |
#4
|
|||
|
|||
error with linked tables manager
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
#7
|
|||
|
|||
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 |
#8
|
|||
|
|||
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 |
#9
|
|||
|
|||
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 |
#10
|
|||
|
|||
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 |
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
No tables in Linked Table Manager (Access2003) | DP | New Users | 3 | August 6th, 2004 09:46 PM |
Linked Tables Manager | Ryan | Database Design | 3 | June 16th, 2004 09:27 PM |
Linked Table Manager | Tony | General Discussion | 3 | June 8th, 2004 11:29 PM |
Unable to see queries with linked tables | Denise P | Mailmerge | 1 | May 19th, 2004 12:01 AM |