Blank Linked Table Manager

A

Al Camp

I'm aware of the bug where the Linked Table manager comes up with no
files displayed. I run A97/A2000/and A2003 on an XP Pro system.

In the past I've used the RegSvr32 function to re-register the
ACCWIX.DLL, and it's always worked. Today... nothing seems to correct the
problem. Perhaps I'm not doing the re-register properly?

My <path> is C:\Program Files\Access2003\Office11\ACCWIZ.DLL (My A2003
location)

I tried...
RegSvr32 C:\Program Files\Access2003\Office11\ACCWIZ.DLL
fails with can't find "C:\Program "

Then tried... (Old DOS path)
RegSvr32 C:\Progra~1\Access~1\Office11\ACCWIZ.DLL
says succesful update... but Linked tables still blank!

Tried (with quotes)
RegSvr32 "C:\Program Files\Access2003\Office11\ACCWIZ.DLL"
says successful update... but Linked tables still blank!

I checked Article 835519 in KB, re: registry editing solution, but I can
not locate the
registry entry they want to edit! (What's HKCR?)
HKCR\TypeLib\{5B87B6F0-17C8-11D0-AD41-00A0C90DC8D9}\8.0\0\win32\<(Default)>

Also reinstalled Access2003... including the Additional Wizards.

Can anyone offer assistance... I'm really stumped right now?
Thanks in advance,
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
 
F

Fred Boer

Dear Al:

Ok, well, a total shot in the dark here... but I have this vague
recollection of dealing with this in the past. I can't recall clearly, but I
think I was having trouble because I had kept Access open, and I needed to
close and re-open Access for it to take effect... An unlikely suggestion,
but..

Good luck!
Fred Boer
 
T

Tom Wickerath

Hi Al,

Your first attempt to reregister failed because the path includes spaces.
You needed to either use the "old DOS path", or enclose the path with double
quotes as you did in the third example.
What's HKCR?
I believe that's shorthand notation for HKEY_CLASSES_ROOT. I have a key for

HKEY_CLASSES_ROOT\TypeLib\{5B87B6F0-17C8-11D0-AD41-00A0C90DC8D9}\8.0\0\win32\

on my PC. The value shown on my PC (I have Access 2002) for (Default) is in
the "old DOS form":

C:\PROGRA~1\MI01DA~1\Office10\ACCWIZ.DLL



Good Luck,
Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

I'm aware of the bug where the Linked Table manager comes up with no
files displayed. I run A97/A2000/and A2003 on an XP Pro system.

In the past I've used the RegSvr32 function to re-register the
ACCWIX.DLL, and it's always worked. Today... nothing seems to correct the
problem. Perhaps I'm not doing the re-register properly?

My <path> is C:\Program Files\Access2003\Office11\ACCWIZ.DLL (My A2003
location)

I tried...
RegSvr32 C:\Program Files\Access2003\Office11\ACCWIZ.DLL
fails with can't find "C:\Program "

Then tried... (Old DOS path)
RegSvr32 C:\Progra~1\Access~1\Office11\ACCWIZ.DLL
says succesful update... but Linked tables still blank!

Tried (with quotes)
RegSvr32 "C:\Program Files\Access2003\Office11\ACCWIZ.DLL"
says successful update... but Linked tables still blank!

I checked Article 835519 in KB, re: registry editing solution, but I can
not locate the
registry entry they want to edit! (What's HKCR?)
HKCR\TypeLib\{5B87B6F0-17C8-11D0-AD41-00A0C90DC8D9}\8.0\0\win32\<(Default)>

Also reinstalled Access2003... including the Additional Wizards.

Can anyone offer assistance... I'm really stumped right now?

Thanks in advance,
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
 
A

Al Camp

Tom,
All set now! Thanks a lot.

Yes, when I saw
...can't find "C:\Program "
I knew I would have to use my the old DOS type pathing. I'm stilll
puzzled as to why attempts #2 and #3 (done repeatedly) appeared to update,
but refused to "take."
That's very odd, as I had done the re-reg a couple of times in the past
with success...

I was not used to the reference HKCR, so my searching didn't come up with
anything. Your explanation of what that stands for really cracked the case.
I found the reg entry right away, and it was indicating my Access 2000 .dll.
Updated the "default" to my path... and voila! It worked right off the
bat...

Thanks Tom, for a speedy... and "dead-on" reply.
 
A

Al Camp

Fred,
Thanks for the reply. Yes, I tried the re-reg with Access open, and with
Access closed. Desperate times require desperate measures!

But, your suggestion is just the thing that might cause this type of
problem... in the whacky world of MS.

Tom Wickerath's reply nailed it. With his help, I was able to do the
registry edit, and I'm all set now.
Thanks for helping out.
 
T

Tom Wickerath

Hi Al,
I'm stilll puzzled as to why attempts #2 and #3 (done repeatedly)
appeared to update, but refused to "take."

I'm very puzzled too. I just got upgraded at my place of work with Windows
XP Pro. and Office 2003. I reinstalled Access 97 on this PC, since I'm
currently involved in converting a huge database from 97 to the current
version. Sure enough, my linked table manager view was also blank.

The regsvr32 utility reported success when I reregistered accwiz.dll,
however, the value shown in the registry was not changed! It still pointed to
the copy of accwiz.dll for Access 97. I had to modify this registry key
manually in order to make it work okay.
Thanks Tom, for a speedy... and "dead-on" reply.
I'm glad I could be of help to you.

Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

Tom,
All set now! Thanks a lot.

Yes, when I saw
...can't find "C:\Program "
I knew I would have to use my the old DOS type pathing. I'm stilll
puzzled as to why attempts #2 and #3 (done repeatedly) appeared to update,
but refused to "take."
That's very odd, as I had done the re-reg a couple of times in the past
with success...

I was not used to the reference HKCR, so my searching didn't come up with
anything. Your explanation of what that stands for really cracked the case.
I found the reg entry right away, and it was indicating my Access 2000 .dll.
Updated the "default" to my path... and voila! It worked right off the
bat...

Thanks Tom, for a speedy... and "dead-on" reply.
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
__________________________________________


Hi Al,

Your first attempt to reregister failed because the path includes spaces.
You needed to either use the "old DOS path", or enclose the path with double
quotes as you did in the third example.
What's HKCR?
I believe that's shorthand notation for HKEY_CLASSES_ROOT. I have a key for

HKEY_CLASSES_ROOT\TypeLib\{5B87B6F0-17C8-11D0-AD41-00A0C90DC8D9}\8.0\0\win32\

on my PC. The value shown on my PC (I have Access 2002) for (Default) is in
the "old DOS form":

C:\PROGRA~1\MI01DA~1\Office10\ACCWIZ.DLL



Good Luck,
Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

I'm aware of the bug where the Linked Table manager comes up with no
files displayed. I run A97/A2000/and A2003 on an XP Pro system.

In the past I've used the RegSvr32 function to re-register the
ACCWIZ.DLL, and it's always worked. Today... nothing seems to correct the
problem. Perhaps I'm not doing the re-register properly?

My <path> is C:\Program Files\Access2003\Office11\ACCWIZ.DLL (My A2003
location)

I tried...
RegSvr32 C:\Program Files\Access2003\Office11\ACCWIZ.DLL
fails with can't find "C:\Program "

Then tried... (Old DOS path)
RegSvr32 C:\Progra~1\Access~1\Office11\ACCWIZ.DLL
says succesful update... but Linked tables still blank!

Tried (with quotes)
RegSvr32 "C:\Program Files\Access2003\Office11\ACCWIZ.DLL"
says successful update... but Linked tables still blank!

I checked Article 835519 in KB, re: registry editing solution, but I can
not locate the
registry entry they want to edit! (What's HKCR?)
HKCR\TypeLib\{5B87B6F0-17C8-11D0-AD41-00A0C90DC8D9}\8.0\0\win32\<(Default)>

Also reinstalled Access2003... including the Additional Wizards.

Can anyone offer assistance... I'm really stumped right now?

Thanks in advance,
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
 
A

Al Camp

Tom,
My registry indicated Access2000 as the culprit! (I have 97/2000/2003
installed) So, that's good to know that others have found the RegSvr
re-register doesn't work reliably. A critical issue in the mechanics of
this bug lays in the fact that Link Tables is used only occaisionaly... so
what and when the bug happened is always uncertain.

I did notice that many of the responses on the Access newsgroups refer
only to the RegSvr "cure", and also, many don't mention the issue of the
<path> addressing scheme on the RegSvr command line. (Quotes/NoQuotes/DOS
Pathing)

I'm going to write up this whole deal in a .txt file, and put it on my
web site, so that all the issues involved in this problem can be clearly
understood by all. (particularly the HKCR "translation")

Thanks for the info Tom...
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
 
T

Tom Wickerath

Hi Al,
I did notice that many of the responses on the Access newsgroups
refer only to the RegSvr "cure", and also, many don't mention the issue
of the <path> addressing scheme on the RegSvr command line.
(Quotes/NoQuotes/DOS Pathing)

My advice is to always include the quotes, even if there are no spaces
included in the path. That way, you only have to remember one way of doing
it. Including the quotes should allow you to always use the more typical long
paths (paths that include more than 8 characters in a folder name and/or
spaces, such as "C:\Program Files\".

Here is a trick that I'll share with you...I never type in the paths myself.
Instead, I use Start > Search > For Files or Folders to find the file in
question (Accwiz.dll). I do not have the search screen maximized. I identify
which file, based on version number, if I find multiple hits for the same
file name. Then I click on Start > Run and enter Regsvr32. That's all that I
type on the Run command line. I then drag the file that I found in the search
results and drop it onto the Start > Run line that already has Regsvr32
entered. You should see that the quotes around the path are automatically
included when you do it this way.

One bit of difficulity that I had last night, at my place of work, when
trying this technique was locating the damn Accwiz.dll file. I'm just getting
used to WindowsXP Professional, since I received a new PC this past Tuesday
morning. I received a message indicating no files found. So, you might want
to add to your write-up to make sure to place a check on Advanced Options in
the search dialog, with Search system folders and Search Subfolders checked.
Without the system folders checked, WindowsXP Pro. will happily report no
files found!

Once you complete your write-up, please consider posting a link for it back
to this thread. If you do this, I'll reference your most excellent page in
any future questions on this topic that I answer.

Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

Tom,
My registry indicated Access2000 as the culprit! (I have 97/2000/2003
installed) So, that's good to know that others have found the RegSvr
re-register doesn't work reliably. A critical issue in the mechanics of
this bug lays in the fact that Link Tables is used only occaisionaly... so
what and when the bug happened is always uncertain.

I did notice that many of the responses on the Access newsgroups refer
only to the RegSvr "cure", and also, many don't mention the issue of the
<path> addressing scheme on the RegSvr command line. (Quotes/NoQuotes/DOS
Pathing)

I'm going to write up this whole deal in a .txt file, and put it on my
web site, so that all the issues involved in this problem can be clearly
understood by all. (particularly the HKCR "translation")

Thanks for the info Tom...
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
__________________________________________


Hi Al,
I'm stilll puzzled as to why attempts #2 and #3 (done repeatedly)
appeared to update, but refused to "take."

I'm very puzzled too. I just got upgraded at my place of work with Windows
XP Pro. and Office 2003. I reinstalled Access 97 on this PC, since I'm
currently involved in converting a huge database from 97 to the current
version. Sure enough, my linked table manager view was also blank.

The regsvr32 utility reported success when I reregistered accwiz.dll,
however, the value shown in the registry was not changed! It still pointed to
the copy of accwiz.dll for Access 97. I had to modify this registry key
manually in order to make it work okay.
Thanks Tom, for a speedy... and "dead-on" reply.
I'm glad I could be of help to you.

Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

Tom,
All set now! Thanks a lot.

Yes, when I saw
...can't find "C:\Program "
I knew I would have to use my the old DOS type pathing. I'm stilll
puzzled as to why attempts #2 and #3 (done repeatedly) appeared to update,
but refused to "take."
That's very odd, as I had done the re-reg a couple of times in the past
with success...

I was not used to the reference HKCR, so my searching didn't come up with
anything. Your explanation of what that stands for really cracked the case.
I found the reg entry right away, and it was indicating my Access 2000 .dll.
Updated the "default" to my path... and voila! It worked right off the
bat...

Thanks Tom, for a speedy... and "dead-on" reply.
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
__________________________________________


Hi Al,

Your first attempt to reregister failed because the path includes spaces.
You needed to either use the "old DOS path", or enclose the path with double
quotes as you did in the third example.
What's HKCR?
I believe that's shorthand notation for HKEY_CLASSES_ROOT. I have a key for

HKEY_CLASSES_ROOT\TypeLib\{5B87B6F0-17C8-11D0-AD41-00A0C90DC8D9}\8.0\0\win32\

on my PC. The value shown on my PC (I have Access 2002) for (Default) is in
the "old DOS form":

C:\PROGRA~1\MI01DA~1\Office10\ACCWIZ.DLL



Good Luck,
Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

I'm aware of the bug where the Linked Table manager comes up with no
files displayed. I run A97/A2000/and A2003 on an XP Pro system.

In the past I've used the RegSvr32 function to re-register the
ACCWIZ.DLL, and it's always worked. Today... nothing seems to correct the
problem. Perhaps I'm not doing the re-register properly?

My <path> is C:\Program Files\Access2003\Office11\ACCWIZ.DLL (My A2003
location)

I tried...
RegSvr32 C:\Program Files\Access2003\Office11\ACCWIZ.DLL
fails with can't find "C:\Program "

Then tried... (Old DOS path)
RegSvr32 C:\Progra~1\Access~1\Office11\ACCWIZ.DLL
says succesful update... but Linked tables still blank!

Tried (with quotes)
RegSvr32 "C:\Program Files\Access2003\Office11\ACCWIZ.DLL"
says successful update... but Linked tables still blank!

I checked Article 835519 in KB, re: registry editing solution, but I can
not locate the
registry entry they want to edit! (What's HKCR?)
HKCR\TypeLib\{5B87B6F0-17C8-11D0-AD41-00A0C90DC8D9}\8.0\0\win32\<(Default)>

Also reinstalled Access2003... including the Additional Wizards.

Can anyone offer assistance... I'm really stumped right now?

Thanks in advance,
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
 
A

Al Camp

Tom,
It may be a while before I get to writing that up, and getting onto the
web site, so I may not post back on this thread. But I'll keep an eye out
for your posts on the NG later, and I'll catch you then. I would appreciate
you input...

Re: Start > Search > For Files... I just used Explorer to determine the
correct path, and then did the paste into RegSvr. I will certainly consider
putting that into my doc.

Re: Where's AccWiz.dll? I may be misunderstanding, but... it's always in
the directory where your Access 2003 is installed.
In my case... C:\Program Files\Access2003\Office11.
In the case of 2000... C:\Program Files\Access2000\Office

Thanks,
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
 
J

Joan Wild

Here's another thought. In the search pane do a search for
Accwiz.dll; Regsvr32.exe

then just drag and drop Accwiz.dll on top of regsvr32.exe.
 
A

Al Camp

Joan,
My doc is posted on my web site (below), under Tips. I gave users 3 ways
to do the RegSvr32 path naming.
Manual, Search Cut&Paste, and Explorer Cut&Paste.
I will try your suggestion...

Installed 2 Access 2003's yesterday with Access 97 previously installed.
One came up blank with Link Mgr, the other worked right out of the box...
go figure.

If you would like to look my fix document over, I would appreciate any
comments.
Thanks
 
J

Joan Wild

Al said:
If you would like to look my fix document over, I would appreciate
any comments.

I'll download it when I get to a faster internet connection later this week.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top