Database Documentor

T

Tony Williams

I have inherited a database which I know contains queries and forms that are
no longer used. Is there anyway I can produce a document which tells me what
forms, reports and queries are used from the Switchboard so that I can
identify any redundant ones?
Thanks
Tony
 
C

ChicagoPete

Tony,
In Access 2007:

One of the best ways to learn about a particular database is by using the
Database Documenter. You use the Database Documenter to build a report
containing detailed information about the objects in a database. You first
choose which objects will be detailed in the report. When you run the
Database Documenter, its report contains all of the data about the database
objects that you selected.

Open the database that you want to document.

On the Database Tools tab, in the Analyze group, click Database Documenter.

In the Documenter dialog box, click the tab that represents the type of
database object that you want to document. To create a report on all of the
objects in a database, click the All Object Types tab.
Select one or more of the objects listed on the tab. To select all of the
objects on a tab, click Select All.

Click OK.

The Database Documenter creates a report that contains detailed data for
each selected object, and then opens the report in Print Preview. For
example, if you run the Database Documenter against a data entry form, the
report created by the Documenter lists the properties for the form as a
whole, the properties for each of the sections in the form, and the
properties for any buttons, labels, text boxes, and other controls on the
form, plus any code modules and user permissions that are associated with the
form.

To print the report, on the Print Preview tab, in the Print group, click
Print.

**************
 
T

Tony Williams

I tried using Documenter, but what I want is a simple report that gives me
the control source of all the forms and reports I have so that I can delete
any queries that are not being used. I've looked at the FMS product and
whilst it looks good it is expensive for this one off exercise. Anyone any
suggestions?
Thanks
Tony
 
J

John Spencer

Products to document the database and do a global find and replace. All have
Access 97 and later versions. Some don't have an Access 2003 version, but may
still work with Access 2003.

Shareware (Try and Buy):
Find and Replace http://www.rickworld.com

Commercial (Try and Buy)
Speed Ferret http://www.moshannon.com

Commercial
Total Access Analyzer http://www.fmsinc.com

Free (For Access XP Only??):
http://www3.bc.sympatico.ca/starthere/findandreplace


Find & Replace: http://www.rickworld.com/products.html
Speed Ferret: http://www.moshannon.com/speedferret.html
Ucora: http://www3.bc.sympatico.ca/starthere/findandreplace/ (Free)
V-Tools: http://www.skrol29.com/us/vtools.php (Free)

Find and replace does have a cross ref capability, however I think you have to
pay for the license to get that capability - approx $40. You can search for
use of a specific form, query, etc. one at a time if you don't want to spend
the cash.

Speed Ferret runs around $200

But if your time is $20 an hour that is only 10 hours - which you will
probably save by having the product available.


John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
 
T

Tony Williams

Thanks John I'll have a look at those.
Tony
John Spencer said:
Products to document the database and do a global find and replace. All
have Access 97 and later versions. Some don't have an Access 2003
version, but may still work with Access 2003.

Shareware (Try and Buy):
Find and Replace http://www.rickworld.com

Commercial (Try and Buy)
Speed Ferret http://www.moshannon.com

Commercial
Total Access Analyzer http://www.fmsinc.com

Free (For Access XP Only??):
http://www3.bc.sympatico.ca/starthere/findandreplace


Find & Replace: http://www.rickworld.com/products.html
Speed Ferret: http://www.moshannon.com/speedferret.html
Ucora: http://www3.bc.sympatico.ca/starthere/findandreplace/ (Free)
V-Tools: http://www.skrol29.com/us/vtools.php (Free)

Find and replace does have a cross ref capability, however I think you
have to pay for the license to get that capability - approx $40. You can
search for use of a specific form, query, etc. one at a time if you don't
want to spend the cash.

Speed Ferret runs around $200

But if your time is $20 an hour that is only 10 hours - which you will
probably save by having the product available.


John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
 
T

Tom Wickerath

I tried using Documenter, but what I want is a simple report that gives me
the control source of all the forms and reports I have so that I can delete
any queries that are not being used.

Forms and reports have a Record Source property, but only controls on forms
and reports include a Control Source property. So, you would need to look at
both the record source and control source properties. What about a query that
serves as the source [virtual] table for one or more queries? You better be
sure to catch these as well.

The FMS product that I pointed you to has a *LOT* more uses than just
identifying unused queries. It will save you loads of time and time is money
as I'm sure you are aware. If it's only use was to identify unused queries, I
would not have mentioned it.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
 
Top