A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Documenter Problems!?



 
 
Thread Tools Display Modes
  #1  
Old April 8th, 2005, 03:49 PM
Rick
external usenet poster
 
Posts: n/a
Default Documenter Problems!?

This appeared to be the best place for this question as it has to do with
wanting to represent my table layouts.

I am an access 97 guy, just upgraded to 2003 for a project, have created
some tables and now want to use "Documenter" to create docs on the details of
those tables.

SO, just as I would in Access 97 I went to tools - Analyze - Documenter
and I receive an "OK only" message box that says "There is no object in this
control".

When I click OK the documenter opens, but is empty, The messagebox reappears
if I click any of the tabs.

Is there something I have to do to make the objects in my new database
documentable?

Thanks in advance.

Rick
  #2  
Old April 8th, 2005, 05:10 PM
Jeff Conrad
external usenet poster
 
Posts: n/a
Default

"Rick" wrote in message:
...

This appeared to be the best place for this question as it has to do with
wanting to represent my table layouts.

I am an access 97 guy, just upgraded to 2003 for a project, have created
some tables and now want to use "Documenter" to create docs on the details of
those tables.

SO, just as I would in Access 97 I went to tools - Analyze - Documenter
and I receive an "OK only" message box that says "There is no object in this
control".

When I click OK the documenter opens, but is empty, The messagebox reappears
if I click any of the tabs.

Is there something I have to do to make the objects in my new database
documentable?


Humm, that's odd.
I did some researching on Access 2003, Documentor, and the error message you
mentioned, but did not find anything. I did find something concerning Access 2000
so perhaps this article will help in your situation.

ACC2000: Error Message When Running Access Wizards:
http://support.microsoft.com/default...b;en-us;303769

Try that and see if that gets the Documentor working.

If you are interested in doing some documentation on your database without
using the Documentor here are some other possibilities for you.

1. I have created a few add-ins that do some specific database documentation.
My "Doug Steele Object Documentor" will create a nice report of all your database
objects for easy reference. The report will list all the objects by category in
alphabetical order in a three-column layout. It looks very sweet in my opinion
and it's even easier to use than the Access Documentor. Plus, you get a nice
report saved in your database that you can open again any time you wish!
There is one version for Access 97 and another version that works for
2000, 2002, and 2003.

You can find the free Add-In on MVP Doug Steele's site he

http://www.accessmvp.com/djste*ele/Documentor.html

I also created an Access Add-In called the "John Viescas Table Documentor"
that documents the table structures. It is even easier to use than the built-in Access
Documentor and creates a slick report that will list each table (including
linked ones) and their field properties in an easy-to-read format. I recently
finished Version 2.0 of the add-in. This version even works on MDE files.

This add-in has not been posted yet to a web site so if you would like
a copy please let me know.

I have another add-in called the "Albert Kallal Database Statistics"
that will make a one-page report that lists the total number of lines of code
in Modules, Forms, and Reports (a sub total for each and a grand total)
as well as a count of each other type of database object (a sub total for
each category and a grand total).

This add-in has not been posted yet to a web site as well so if you would like
a copy please let me know.

I have another add-in that will, among other things, document the User
and Group permissions in a secured database. You can find that add-in
on MVP Sandra Daigle's site here (at the top):

http://www.daiglenet.com/msaccess.htm

2. David Hare-Scott has also written a simple table documentor.
You can download it he
http://www.rogersaccesslibrary*.com/...e-S*cott,David

3. Armen Stein has something here as well:
http://www.jstreettech.com/cartgenie...rDownloads.asp
(Look for Data Dictionary Report Utility)

4. You can buy a commercial product like this one that will produce a wealth
of information:
http://www.fmsinc.com/Products*/analyzer/index.html

Hope that gives you some ideas.
Let us know how it goes.
--
Jeff Conrad
Access Junkie
Bend, Oregon


  #3  
Old April 8th, 2005, 09:24 PM
Immanuel Sibero
external usenet poster
 
Posts: n/a
Default


Jeff,

That's quite a wealth of information.
I almost need a documentor just to document all the places where I can find
all the various Access documentors. :-)


Immanuel Sibero



"Jeff Conrad" wrote in message
...
"Rick" wrote in message:
...

This appeared to be the best place for this question as it has to do

with
wanting to represent my table layouts.

I am an access 97 guy, just upgraded to 2003 for a project, have created
some tables and now want to use "Documenter" to create docs on the

details of
those tables.

SO, just as I would in Access 97 I went to tools - Analyze -

Documenter
and I receive an "OK only" message box that says "There is no object in

this
control".

When I click OK the documenter opens, but is empty, The messagebox

reappears
if I click any of the tabs.

Is there something I have to do to make the objects in my new database
documentable?


Humm, that's odd.
I did some researching on Access 2003, Documentor, and the error message

you
mentioned, but did not find anything. I did find something concerning

Access 2000
so perhaps this article will help in your situation.

ACC2000: Error Message When Running Access Wizards:
http://support.microsoft.com/default...b;en-us;303769

Try that and see if that gets the Documentor working.

If you are interested in doing some documentation on your database without
using the Documentor here are some other possibilities for you.

1. I have created a few add-ins that do some specific database

documentation.
My "Doug Steele Object Documentor" will create a nice report of all your

database
objects for easy reference. The report will list all the objects by

category in
alphabetical order in a three-column layout. It looks very sweet in my

opinion
and it's even easier to use than the Access Documentor. Plus, you get a

nice
report saved in your database that you can open again any time you wish!
There is one version for Access 97 and another version that works for
2000, 2002, and 2003.

You can find the free Add-In on MVP Doug Steele's site he

http://www.accessmvp.com/djste*ele/Documentor.html

I also created an Access Add-In called the "John Viescas Table Documentor"
that documents the table structures. It is even easier to use than the

built-in Access
Documentor and creates a slick report that will list each table (including
linked ones) and their field properties in an easy-to-read format. I

recently
finished Version 2.0 of the add-in. This version even works on MDE files.

This add-in has not been posted yet to a web site so if you would like
a copy please let me know.

I have another add-in called the "Albert Kallal Database Statistics"
that will make a one-page report that lists the total number of lines of

code
in Modules, Forms, and Reports (a sub total for each and a grand total)
as well as a count of each other type of database object (a sub total for
each category and a grand total).

This add-in has not been posted yet to a web site as well so if you would

like
a copy please let me know.

I have another add-in that will, among other things, document the User
and Group permissions in a secured database. You can find that add-in
on MVP Sandra Daigle's site here (at the top):

http://www.daiglenet.com/msaccess.htm

2. David Hare-Scott has also written a simple table documentor.
You can download it he
http://www.rogersaccesslibrary*.com/...e-S*cott,David

3. Armen Stein has something here as well:
http://www.jstreettech.com/cartgenie...rDownloads.asp
(Look for Data Dictionary Report Utility)

4. You can buy a commercial product like this one that will produce a

wealth
of information:
http://www.fmsinc.com/Products*/analyzer/index.html

Hope that gives you some ideas.
Let us know how it goes.
--
Jeff Conrad
Access Junkie
Bend, Oregon




  #4  
Old April 8th, 2005, 09:40 PM
Jeff Conrad
external usenet poster
 
Posts: n/a
Default

"Immanuel Sibero" wrote in message:
...

Jeff,

That's quite a wealth of information.
I almost need a documentor just to document all the places where I can find
all the various Access documentors. :-)


Too brief you think?
I'll go looking for some more.

;-)
--
Jeff Conrad
Access Junkie
Bend, Oregon


  #5  
Old April 11th, 2005, 02:33 PM
Rick
external usenet poster
 
Posts: n/a
Default

First off THANKS YOU! The step in the doc
"Method 4
Use Regsvr32.exe to register the Accwiz.dll file again: 1. On the taskbar,
click Start, and then click Run.
2. Type the following command in the Open box, and then click OK:

Regsvr32.exe Accwiz.dll"

Was the solution to the original problem. Did that and all was good.

Now for your above and beyond (Thanks for that as well!)


When I go to YOUR page I can't see anything to down load. I see a large
image that does not load, a link for Doug Steel that seems to go no where and
one for Arvin, does the same.

I find similar problems when I try some of the others you recommended, I am
not sure if it has something to do with our Corp Firewall, my stupidity
(Likely one of those) or there is something wrong with the sites (I doubt, to
many to be a coincidents).

But I really do apprecite your help and hope you have a great week!!

Rick


"Jeff Conrad" wrote:

"Rick" wrote in message:
...

This appeared to be the best place for this question as it has to do with
wanting to represent my table layouts.

I am an access 97 guy, just upgraded to 2003 for a project, have created
some tables and now want to use "Documenter" to create docs on the details of
those tables.

SO, just as I would in Access 97 I went to tools - Analyze - Documenter
and I receive an "OK only" message box that says "There is no object in this
control".

When I click OK the documenter opens, but is empty, The messagebox reappears
if I click any of the tabs.

Is there something I have to do to make the objects in my new database
documentable?


Humm, that's odd.
I did some researching on Access 2003, Documentor, and the error message you
mentioned, but did not find anything. I did find something concerning Access 2000
so perhaps this article will help in your situation.

ACC2000: Error Message When Running Access Wizards:
http://support.microsoft.com/default...b;en-us;303769

Try that and see if that gets the Documentor working.

If you are interested in doing some documentation on your database without
using the Documentor here are some other possibilities for you.

1. I have created a few add-ins that do some specific database documentation.
My "Doug Steele Object Documentor" will create a nice report of all your database
objects for easy reference. The report will list all the objects by category in
alphabetical order in a three-column layout. It looks very sweet in my opinion
and it's even easier to use than the Access Documentor. Plus, you get a nice
report saved in your database that you can open again any time you wish!
There is one version for Access 97 and another version that works for
2000, 2002, and 2003.

You can find the free Add-In on MVP Doug Steele's site he

http://www.accessmvp.com/djsteÂ*ele/Documentor.html

I also created an Access Add-In called the "John Viescas Table Documentor"
that documents the table structures. It is even easier to use than the built-in Access
Documentor and creates a slick report that will list each table (including
linked ones) and their field properties in an easy-to-read format. I recently
finished Version 2.0 of the add-in. This version even works on MDE files.

This add-in has not been posted yet to a web site so if you would like
a copy please let me know.

I have another add-in called the "Albert Kallal Database Statistics"
that will make a one-page report that lists the total number of lines of code
in Modules, Forms, and Reports (a sub total for each and a grand total)
as well as a count of each other type of database object (a sub total for
each category and a grand total).

This add-in has not been posted yet to a web site as well so if you would like
a copy please let me know.

I have another add-in that will, among other things, document the User
and Group permissions in a secured database. You can find that add-in
on MVP Sandra Daigle's site here (at the top):

http://www.daiglenet.com/msaccess.htm

2. David Hare-Scott has also written a simple table documentor.
You can download it he
http://www.rogersaccesslibraryÂ*.com...-SÂ*cott,David

3. Armen Stein has something here as well:
http://www.jstreettech.com/cartgenie...rDownloads.asp
(Look for Data Dictionary Report Utility)

4. You can buy a commercial product like this one that will produce a wealth
of information:
http://www.fmsinc.com/ProductsÂ*/analyzer/index.html

Hope that gives you some ideas.
Let us know how it goes.
--
Jeff Conrad
Access Junkie
Bend, Oregon



  #6  
Old April 11th, 2005, 02:39 PM
Rick
external usenet poster
 
Posts: n/a
Default

I was able to browse back then manually find yours at
http://www.accessmvp.com/DJSteele/Documentor.html . Don't know why when I
clicked the link myself it DNW.

Thanks again!

"Rick" wrote:

First off THANKS YOU! The step in the doc
"Method 4
Use Regsvr32.exe to register the Accwiz.dll file again: 1. On the taskbar,
click Start, and then click Run.
2. Type the following command in the Open box, and then click OK:

Regsvr32.exe Accwiz.dll"

Was the solution to the original problem. Did that and all was good.

Now for your above and beyond (Thanks for that as well!)


When I go to YOUR page I can't see anything to down load. I see a large
image that does not load, a link for Doug Steel that seems to go no where and
one for Arvin, does the same.

I find similar problems when I try some of the others you recommended, I am
not sure if it has something to do with our Corp Firewall, my stupidity
(Likely one of those) or there is something wrong with the sites (I doubt, to
many to be a coincidents).

But I really do apprecite your help and hope you have a great week!!

Rick


"Jeff Conrad" wrote:

"Rick" wrote in message:
...

This appeared to be the best place for this question as it has to do with
wanting to represent my table layouts.

I am an access 97 guy, just upgraded to 2003 for a project, have created
some tables and now want to use "Documenter" to create docs on the details of
those tables.

SO, just as I would in Access 97 I went to tools - Analyze - Documenter
and I receive an "OK only" message box that says "There is no object in this
control".

When I click OK the documenter opens, but is empty, The messagebox reappears
if I click any of the tabs.

Is there something I have to do to make the objects in my new database
documentable?


Humm, that's odd.
I did some researching on Access 2003, Documentor, and the error message you
mentioned, but did not find anything. I did find something concerning Access 2000
so perhaps this article will help in your situation.

ACC2000: Error Message When Running Access Wizards:
http://support.microsoft.com/default...b;en-us;303769

Try that and see if that gets the Documentor working.

If you are interested in doing some documentation on your database without
using the Documentor here are some other possibilities for you.

1. I have created a few add-ins that do some specific database documentation.
My "Doug Steele Object Documentor" will create a nice report of all your database
objects for easy reference. The report will list all the objects by category in
alphabetical order in a three-column layout. It looks very sweet in my opinion
and it's even easier to use than the Access Documentor. Plus, you get a nice
report saved in your database that you can open again any time you wish!
There is one version for Access 97 and another version that works for
2000, 2002, and 2003.

You can find the free Add-In on MVP Doug Steele's site he

http://www.accessmvp.com/djsteÂ*ele/Documentor.html

I also created an Access Add-In called the "John Viescas Table Documentor"
that documents the table structures. It is even easier to use than the built-in Access
Documentor and creates a slick report that will list each table (including
linked ones) and their field properties in an easy-to-read format. I recently
finished Version 2.0 of the add-in. This version even works on MDE files.

This add-in has not been posted yet to a web site so if you would like
a copy please let me know.

I have another add-in called the "Albert Kallal Database Statistics"
that will make a one-page report that lists the total number of lines of code
in Modules, Forms, and Reports (a sub total for each and a grand total)
as well as a count of each other type of database object (a sub total for
each category and a grand total).

This add-in has not been posted yet to a web site as well so if you would like
a copy please let me know.

I have another add-in that will, among other things, document the User
and Group permissions in a secured database. You can find that add-in
on MVP Sandra Daigle's site here (at the top):

http://www.daiglenet.com/msaccess.htm

2. David Hare-Scott has also written a simple table documentor.
You can download it he
http://www.rogersaccesslibraryÂ*.com...-SÂ*cott,David

3. Armen Stein has something here as well:
http://www.jstreettech.com/cartgenie...rDownloads.asp
(Look for Data Dictionary Report Utility)

4. You can buy a commercial product like this one that will produce a wealth
of information:
http://www.fmsinc.com/ProductsÂ*/analyzer/index.html

Hope that gives you some ideas.
Let us know how it goes.
--
Jeff Conrad
Access Junkie
Bend, Oregon



  #7  
Old April 11th, 2005, 02:46 PM
Rick
external usenet poster
 
Posts: n/a
Default

OK, now maybe I am a bigger idiot than my wife reminded me I am this morning.
.. . When I try to run Dougs Documentor I get a runtime error "

"The following error has occured: Error Number 7874 Error Description
Microsoft Office Access can't find the object report1."

I likely missed something along the way. I will tinker and try to figure it
out.

This DB HAS no reports yet, only tables. Maybe it is assuming at least one!?

Rick


"Jeff Conrad" wrote:

"Rick" wrote in message:
...

This appeared to be the best place for this question as it has to do with
wanting to represent my table layouts.

I am an access 97 guy, just upgraded to 2003 for a project, have created
some tables and now want to use "Documenter" to create docs on the details of
those tables.

SO, just as I would in Access 97 I went to tools - Analyze - Documenter
and I receive an "OK only" message box that says "There is no object in this
control".

When I click OK the documenter opens, but is empty, The messagebox reappears
if I click any of the tabs.

Is there something I have to do to make the objects in my new database
documentable?


Humm, that's odd.
I did some researching on Access 2003, Documentor, and the error message you
mentioned, but did not find anything. I did find something concerning Access 2000
so perhaps this article will help in your situation.

ACC2000: Error Message When Running Access Wizards:
http://support.microsoft.com/default...b;en-us;303769

Try that and see if that gets the Documentor working.

If you are interested in doing some documentation on your database without
using the Documentor here are some other possibilities for you.

1. I have created a few add-ins that do some specific database documentation.
My "Doug Steele Object Documentor" will create a nice report of all your database
objects for easy reference. The report will list all the objects by category in
alphabetical order in a three-column layout. It looks very sweet in my opinion
and it's even easier to use than the Access Documentor. Plus, you get a nice
report saved in your database that you can open again any time you wish!
There is one version for Access 97 and another version that works for
2000, 2002, and 2003.

You can find the free Add-In on MVP Doug Steele's site he

http://www.accessmvp.com/djsteÂ*ele/Documentor.html

I also created an Access Add-In called the "John Viescas Table Documentor"
that documents the table structures. It is even easier to use than the built-in Access
Documentor and creates a slick report that will list each table (including
linked ones) and their field properties in an easy-to-read format. I recently
finished Version 2.0 of the add-in. This version even works on MDE files.

This add-in has not been posted yet to a web site so if you would like
a copy please let me know.

I have another add-in called the "Albert Kallal Database Statistics"
that will make a one-page report that lists the total number of lines of code
in Modules, Forms, and Reports (a sub total for each and a grand total)
as well as a count of each other type of database object (a sub total for
each category and a grand total).

This add-in has not been posted yet to a web site as well so if you would like
a copy please let me know.

I have another add-in that will, among other things, document the User
and Group permissions in a secured database. You can find that add-in
on MVP Sandra Daigle's site here (at the top):

http://www.daiglenet.com/msaccess.htm

2. David Hare-Scott has also written a simple table documentor.
You can download it he
http://www.rogersaccesslibraryÂ*.com...-SÂ*cott,David

3. Armen Stein has something here as well:
http://www.jstreettech.com/cartgenie...rDownloads.asp
(Look for Data Dictionary Report Utility)

4. You can buy a commercial product like this one that will produce a wealth
of information:
http://www.fmsinc.com/ProductsÂ*/analyzer/index.html

Hope that gives you some ideas.
Let us know how it goes.
--
Jeff Conrad
Access Junkie
Bend, Oregon



  #8  
Old April 11th, 2005, 07:40 PM
Jeff Conrad
external usenet poster
 
Posts: n/a
Default

"Rick" wrote in message:
...

I was able to browse back then manually find yours at
http://www.accessmvp.com/DJSteele/Documentor.html . Don't know why when I
clicked the link myself it DNW.

Thanks again!


The links work Ok for me.
It does sound like maybe your company's firewall was interferring.

--
Jeff Conrad
Access Junkie
Bend, Oregon


  #9  
Old April 11th, 2005, 07:44 PM
Jeff Conrad
external usenet poster
 
Posts: n/a
Default

"Rick" wrote in message:
...

OK, now maybe I am a bigger idiot than my wife reminded me I am this morning.
. . When I try to run Dougs Documentor I get a runtime error "

"The following error has occurred: Error Number 7874 Error Description
Microsoft Office Access can't find the object report1."

I likely missed something along the way. I will tinker and try to figure it
out.

This DB HAS no reports yet, only tables. Maybe it is assuming at least one!?


Humm, since this is a "problem" Doug should be answering this one.
(Sorry, inside joke)
g

I've been using the add-in for nearly a year and never ran into that
error before. A couple things to try:
1. Compact the database. There could have been a residual temporary
report in memory called Report1 that is in the System Tables.
2. Try running the add-in on a different database. Make sure it is a
backup copy though. Any errors on this other file?

Which Access version are you running by the way?

--
Jeff Conrad
Access Junkie
Bend, Oregon


  #10  
Old August 9th, 2005, 09:52 PM
Luther
external usenet poster
 
Posts: n/a
Default

Hello,

I, too, am looking for an alternative to the built-in documenter. Please
send me the "John Viescas Table Documentor" to .

Thanks again.

"Jeff Conrad" wrote:

"Rick" wrote in message:
...

I was able to browse back then manually find yours at
http://www.accessmvp.com/DJSteele/Documentor.html . Don't know why when I
clicked the link myself it DNW.

Thanks again!


The links work Ok for me.
It does sound like maybe your company's firewall was interferring.

--
Jeff Conrad
Access Junkie
Bend, Oregon



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Email send problems with DSL & Outlook bmcdermo General Discussion 3 April 1st, 2005 02:43 PM
Disconnect Problems with Sending Email jeff General Discussion 4 January 18th, 2005 06:36 PM
Access Documenter in 2003 Margaret General Discussion 7 October 6th, 2004 05:22 AM
problems initiating mplay32.exe electricrainbowfish Powerpoint 8 July 8th, 2004 09:37 AM
Problems with Style formatting terrapinie Formatting Long Documents 2 July 7th, 2004 06:18 PM


All times are GMT +1. The time now is 05:54 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.