Access 2003 - Documenter - Not showing any data

[jh]

Odd Problem as arisen

Access 2003 - Documenter was working, now for some reason it does not show
any data when run, I've tried 3 different Access databases. Funny thing is,
it WAS working last week. I've checked the options, and they are all set to
bring out all data for the table or query that I chose to document.

Is the Documenter gone for the weekend? LOL.

 

[Guest]

Hi JH,

When you say "it does not show any data when run", are you indicating that
it does not show any of your objects (tables, queries, forms, reports, etc.)
when run, or are you saying that after you select some objects to document,
the end result is a blank report?

Here is my standard blurb for wizard related problems:

Try the following steps. You possibly have other wizards that are not
functional as well.

Replace three files on your hard drive, Acwzmain.mde, Acwzlib.mde and
Acwztool.mde, using the instructions shown in KB 303769. One or more of these
files may have become corrupted. Do this without Access running.

http://support.microsoft.com/?id=303769
http://support.microsoft.com/?id=833220 <--- Error in loading DLL

1.) Insert the Microsoft Office or Access compact disc.
2.) By using Windows Explorer, open the Pfiles\Msoffice\Office\1033
folder on your CD-ROM or DVD-ROM drive, and locate the
Acwzmain.mde, Acwzlib.mde and Acwztool.mde files.
3.) Select these files, and then click Copy on the Edit menu
4.) Open the folder that you installed Office into. The default folder is
C:\Program Files\Microsoft Office. Select the Office\1033 folder,
and then on the Edit menu, click Paste.

If that doesn't fix the problem, try re-registering the Accwiz.dll,
Msado15.dll and DAO360.dll files. Click on Start > Run. Then enter the
commands:

Regsvr32 Accwiz.dll
Regsvr32 "C:\Program Files\Common Files\system\ado\Msado15.dll"
Regsvr32 "C:\Program Files\Common Files\Microsoft Shared\DAO\Dao360.dll"

Wizard starts, but “No valid fields can be found†error message may be
related to overly aggressive settings on antivirus software:

http://groups.google.com/group/micr..._frm/thread/287b312d799c6739/2543458dbca8ddde
and
http://alexdyb.blogspot.com/2006/02/be-careful-with-kaspersky-anti-virus.html


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[jh]

When I select a table or query I want documented, the report is blank, other
than the header.

if I go in and select and deselect some items in the options and then run
the documenter, then nothing is returned by the documenter.

However, I have found a work around on the web to delete a registry key that
is created when the
options are changed. If I delete that, and run the documenter without any
changes, than
the data is displayed ( no reg key created) and then as soon as I change the
options a
reg key is entered and no data is returned.

I will try what you reccommend in the A.M

 

[Guest]

Hi JH,

Very interesting. Can you provide the link where you found the registry key
suggestion?


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[jh]

HKEY_Current_User\Software\Microsoft\Office\11.0\Access\Wizards\Preferences\Documentor

delete Option 00 and Option 01

from the post in this group (via google search)

While I don't have a solutiont, I have a work around. Open regedit and go
to
"HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Access\Wizards\Preference­s\Documentor".
Note 11.0 is 2003 if you are having this problem with a different version
it
will be a different number. When you click on that path you will see a key
"Option00" with some number in it. This is the setting for the dialog box
but for some reason it is not being read. DELETE that key, resetting the
number has no effect. If you go into the option dialog, all the settings
will be checked again. DO NOT SELECT "OK" or the "Option00' key will be
created and you will be back to the same problem. Select Cancel and it
should work.

 

[jh]

Ok,

So, for some reason when I installed Office, the three files

acwzmain.med , acwzlib.mde acwztool.mde were not in the 1033 directory, so
as suggested copied them from the source and all is well now.

Thanks, but the reg key thing is interesting isn't it?

 

[Guest]

Hi JH,

Thanks for providing the follow-up. Yes, the registry hack is interesting.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________