| Author |
Linked Table Manager Doesn't Work in Access 2003
|
|
| dnitz 2005-06-24, 11:25 am |
| 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.
| |
| Joan Wild 2005-06-24, 8:24 pm |
| "dnitz" <dnitz@discussions.microsoft.com> wrote in message
news:15B71C23-03D4-4065-A734- F893C4D82E6C@microso
ft.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 2005-06-27, 11:24 am |
| 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\accw
iz.dll
I received the following error message:
LoadLibrary Failed ("C:\Program") failed-The specified module could not be
found.
"Joan Wild" wrote:
> "dnitz" <dnitz@discussions.microsoft.com> wrote in message
> news:15B71C23-03D4-4065-A734- F893C4D82E6C@microso
ft.com...
>
> 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 Wild 2005-06-27, 11:24 am |
| "dnitz" <dnitz@discussions.microsoft.com> wrote in message
news:1F2993E7-A860-4364-B670- 936E32C3256C@microso
ft.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\accw
iz.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\accw
iz.dll"
--
Joan Wild
Microsoft Access MVP
| |
| Albert D.Kallal 2005-06-27, 1:24 pm |
| > regsvr32.exe C:\Program Files\Microsoft Office\OFFICE11\accw
iz.dll
Try putting quotes around the above
so, go start->run, and paste in
regsvr32.exe "C:\Program Files\Microsoft Office\OFFICE11\accw
iz.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" <dnitz@discussions.microsoft.com> wrote in message
> news:1F2993E7-A860-4364-B670- 936E32C3256C@microso
ft.com...
>
>
> You need to enclose the path in double quotes because it has a space in it.
> regsvr32.exe "C:\Program Files\Microsoft Office\Office11\accw
iz.dll"
>
> --
> Joan Wild
> Microsoft Access MVP
>
>
>
| |
| Joan Wild 2005-06-27, 8:25 pm |
| "dnitz" <dnitz@discussions.microsoft.com> wrote in message
news:DC786C2C-2DCE-4151-AE43- 78762F7DABD2@microso
ft.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
|
|
|
|