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 |
#11
|
|||
|
|||
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 |
#12
|
|||
|
|||
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 |
#13
|
|||
|
|||
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 |
#14
|
|||
|
|||
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 |
#15
|
|||
|
|||
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 |
#16
|
|||
|
|||
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 |
#17
|
|||
|
|||
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 |
|
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 |