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.
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