I recently upgraded to Access 2003 and have found that the menu option: Tools/Database Utilities/Linked Table Manager no longer works correctly for re-linking my front end database to the backend. No tables show in the table list. If I click “Select All” and then fill in the path to the backend database I get the following error message: Method ‘List’ of object ‘IfieldListWnd’ failed. As a work around I have to delete all the table links from the front-end and then File/Get External Data/Link Tables. Is anybody else having this problem? Thanks in advance for your help.
"dnitz" wrote in message news:15B71C23-03D4-4065-A734-F893C4D82E6C@microsoft.com... >I recently upgraded to Access 2003 and have found that the menu option: > Tools/Database Utilities/Linked Table Manager no longer works correctly > for > re-linking my front end database to the backend. No tables show in the > table > list. Re-register accwiz.dll (the one located in the same folder where Access 2003 is installed) Regsvr32 "path\ACCWIZ.DLL" See http://support.microsoft.com/?id=835519 -- Joan Wild Microsoft Access MVP
Joan, Thank you for the information. I located the correct version of the Accwiz.dll and tried to register it but the command fails. I ran the following command: regsvr32.exe C:\Program Files\Microsoft Office\OFFICE11\accwiz.dll I received the following error message: LoadLibrary Failed ("C:\Program") failed-The specified module could not be found. "Joan Wild" wrote: > "dnitz" wrote in message > news:15B71C23-03D4-4065-A734-F893C4D82E6C@microsoft.com... > >I recently upgraded to Access 2003 and have found that the menu option: > > Tools/Database Utilities/Linked Table Manager no longer works correctly > > for > > re-linking my front end database to the backend. No tables show in the > > table > > list. > > Re-register accwiz.dll (the one located in the same folder where Access 2003 > is installed) > > Regsvr32 "path\ACCWIZ.DLL" > See > http://support.microsoft.com/?id=835519 > > > > -- > Joan Wild > Microsoft Access MVP > > >
"dnitz" wrote in message news:1F2993E7-A860-4364-B670-936E32C3256C@microsoft.com... > Joan, > > Thank you for the information. I located the correct version of the > Accwiz.dll and tried to register it but the command fails. I ran the > following command: > regsvr32.exe C:\Program Files\Microsoft Office\OFFICE11\accwiz.dll > > I received the following error message: > LoadLibrary Failed ("C:\Program") failed-The specified module could not be > found. You need to enclose the path in double quotes because it has a space in it. regsvr32.exe "C:\Program Files\Microsoft Office\Office11\accwiz.dll" -- Joan Wild Microsoft Access MVP
> regsvr32.exe C:\Program Files\Microsoft Office\OFFICE11\accwiz.dll Try putting quotes around the above so, go start->run, and paste in regsvr32.exe "C:\Program Files\Microsoft Office\OFFICE11\accwiz.dll" -- Albert D. Kallal (Access MVP) Edmonton, Alberta Canada pleaseNOOSpamKallal@msn.com http://www.members.shaw.ca/AlbertKallal
Joan and Albert, Thanks to both of you. It worked like a charm and my Linked Table Manager is now working correctly. "Joan Wild" wrote: > "dnitz" wrote in message > news:1F2993E7-A860-4364-B670-936E32C3256C@microsoft.com... > > Joan, > > > > Thank you for the information. I located the correct version of the > > Accwiz.dll and tried to register it but the command fails. I ran the > > following command: > > regsvr32.exe C:\Program Files\Microsoft Office\OFFICE11\accwiz.dll > > > > I received the following error message: > > LoadLibrary Failed ("C:\Program") failed-The specified module could not be > > found. > > > You need to enclose the path in double quotes because it has a space in it. > regsvr32.exe "C:\Program Files\Microsoft Office\Office11\accwiz.dll" > > -- > Joan Wild > Microsoft Access MVP > > >
"dnitz" wrote in message news:DC786C2C-2DCE-4151-AE43-78762F7DABD2@microsoft.com... > Joan and Albert, > > Thanks to both of you. It worked like a charm and my Linked Table Manager > is now working correctly. > You're welcome! -- Joan Wild Microsoft Access MVP
