Simple way to document DB objects

[jmillerWV]

This may have been asked before but I could not find it. I have an Access
2003 DB that I am getting ready to upsize to SQL 2000. What I need is a
simple way to list the objects (queries, forms, reports and so on) and the
fileds each use. I do not need properties, indexes and so on, only the object
and field names. I have tried the "documentor" wizard in every configuration
but it will not give me what I need. I found a VBA script to extract the
names of objects but am unable to get the names of the fields. I want to be
able to creat a table of objects and their fileds. I need to change some of
the field names in the tables and need a simple way to find these in the
other objects. Thanks in advance

 

[Ed Metcalfe]

This may have been asked before but I could not find it. I have an
Access 2003 DB that I am getting ready to upsize to SQL 2000. What I
need is a simple way to list the objects (queries, forms, reports and so
on) and the fileds each use. I do not need properties, indexes and so
on, only the object and field names. I have tried the "documentor"
wizard in every configuration but it will not give me what I need. I
found a VBA script to extract the names of objects but am unable to get
the names of the fields. I want to be able to creat a table of objects
and their fileds. I need to change some of the field names in the tables
and need a simple way to find these in the other objects. Thanks in
advance

http://mdbdoc.sourceforge.net/ should give you what you want...

Ed Metcalfe.

 

[John W. Vinson]

This may have been asked before but I could not find it. I have an Access
2003 DB that I am getting ready to upsize to SQL 2000. What I need is a
simple way to list the objects (queries, forms, reports and so on) and the
fileds each use. I do not need properties, indexes and so on, only the object
and field names. I have tried the "documentor" wizard in every configuration
but it will not give me what I need. I found a VBA script to extract the
names of objects but am unable to get the names of the fields. I want to be
able to creat a table of objects and their fileds. I need to change some of
the field names in the tables and need a simple way to find these in the
other objects. Thanks in advance

Several third party options:

Free: http://www3.bc.sympatico.ca/starthere/findandreplace
Find and Replace: http://www.rickworld.com
Speed Ferret: http://www.moshannon.com (may not be available for 2003)
Total Access Analyzer: http://www.fmsinc.com