Identify fields in a DB

G

Greg

I have built a database using Access 2000 with about 15 tables.
I have experimented with the Access 2000 TOOLS>ANALYZE>DOCUMENTER and found
it somewhat helpful.
However what I would like to see is a list of all fields in the entire DB
followed by the tables they are contained within.
I am new and tried to normalize and do things correctly but have still
probably duplicated data unnecessarily.
Does anyone know if there is a way to get a list of fields across the entire
data base rather than by table, so I can review what I have done.

A member of the newsgroup, Mr. Dewey told me how to do what I want but I
could not follow his suggestion (my fault I'm sure).
Any help would be appreciated.
Greg
 
T

Tom Wickerath

Hi Greg,

Why don't you post Mr. Dewey's solution, along with whatever questions that
you might have for how to implement it?

Tom
______________________________________

:

I have built a database using Access 2000 with about 15 tables.
I have experimented with the Access 2000 TOOLS>ANALYZE>DOCUMENTER and found
it somewhat helpful.
However what I would like to see is a list of all fields in the entire DB
followed by the tables they are contained within.
I am new and tried to normalize and do things correctly but have still
probably duplicated data unnecessarily.
Does anyone know if there is a way to get a list of fields across the entire
data base rather than by table, so I can review what I have done.

A member of the newsgroup, Mr. Dewey told me how to do what I want but I
could not follow his suggestion (my fault I'm sure).
Any help would be appreciated.
Greg
 
T

Tom Wickerath

Hello again -

I found Karl's answer, and I agree that it's not necessarily the easiest to
follow. Here is a solution that might work for you, without the need to write
any code. Start by downloading & installing a copy of Jeff Conrads documentor
tool:

http://home.bendbroadband.com/conradsystems/accessjunkie/csdtools.html

Run the report for documenting tables. With the report open, click on File >
Export. Save the file in your preferred format (text, RTF, etc.). Then open
the output file and rearrange it to your liking.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

Hi Greg,

Why don't you post Mr. Dewey's solution, along with whatever questions that
you might have for how to implement it?

Tom
______________________________________

:

I have built a database using Access 2000 with about 15 tables.
I have experimented with the Access 2000 TOOLS>ANALYZE>DOCUMENTER and found
it somewhat helpful.
However what I would like to see is a list of all fields in the entire DB
followed by the tables they are contained within.
I am new and tried to normalize and do things correctly but have still
probably duplicated data unnecessarily.
Does anyone know if there is a way to get a list of fields across the entire
data base rather than by table, so I can review what I have done.

A member of the newsgroup, Mr. Dewey told me how to do what I want but I
could not follow his suggestion (my fault I'm sure).
Any help would be appreciated.
Greg
 
G

Greg

Tom,
Thank you I will give it a try in the latter AM. I do not want to look a
gift horse in the mouth but is the bendbroadband.com safe? I am not trying
to offend anyone!

Thank You,
Greg
 
J

Jeff Conrad

in message:
Tom,
Thank you I will give it a try in the latter AM. I do not want to look a
gift horse in the mouth but is the bendbroadband.com safe? I am not trying
to offend anyone!
Click to expand...

ROFL!!!!!!!
Sorry, couldn't help myself there!
:)

Well I can't speak for other sites on the bendbroadband network, but
my site is pretty harmless. Considering the number of page hits and unique
visitors (which you can see listed on my main Access page) you won't
be the first visitor.

The CSD Tools 97 add-in has been downloaded 31 times and the
2000 version 133 times. You're not alone Greg.

About the only "harm" that may come is that you
will become an Access Junkie and one with Access Collective.
;-)
 
T

Tom Wickerath

Hi Greg,

I can assure you that Jeff Conrad's web site, and his utility, is perfectly
safe. Jeff is one of Microsoft's newest MVP's (Most Valuble Professional),
having just been awarded MVP status at the beginning of July:

http://www.microsoft.com/communitie...603"/^~sParams^~/sParams^~/CMTYDataSvcParams^

Note: If the above link is broken, you can start here:
http://www.microsoft.com/communities/MVP/MVP.mspx

Find the link for "Microsoft Office Access". Jeff's info. is shown on page 2.

Jeff would have too much to lose by offering a utility that included any
kind of virus or spyware. Besides, his brother is a police officer (see the
recent issue of Newsweek Magazine, with link provided below), so he'd get
busted big time if he even *thought* about publishing a utility that did
anything surreptitious!

http://www.msnbc.msn.com/id/8359747/site/newsweek/

But, I can assure you that such thoughts would never even enter into Jeff's
head.

He does include a fair warning to back up your database before using his
tool, but I can tell you that I've never had any problem using his utility.

Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

Tom,
Thank you I will give it a try in the latter AM. I do not want to look a
gift horse in the mouth but is the bendbroadband.com safe? I am not trying
to offend anyone!

Thank You,
Greg
__________________________________________

Hello again -

I found Karl's answer, and I agree that it's not necessarily the easiest to
follow. Here is a solution that might work for you, without the need to write
any code. Start by downloading & installing a copy of Jeff Conrads documentor
tool:

http://home.bendbroadband.com/conradsystems/accessjunkie/csdtools.html

Run the report for documenting tables. With the report open, click on File >
Export. Save the file in your preferred format (text, RTF, etc.). Then open
the output file and rearrange it to your liking.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

Hi Greg,

Why don't you post Mr. Dewey's solution, along with whatever questions that
you might have for how to implement it?

Tom
______________________________________

:

I have built a database using Access 2000 with about 15 tables.
I have experimented with the Access 2000 TOOLS>ANALYZE>DOCUMENTER and found
it somewhat helpful.
However what I would like to see is a list of all fields in the entire DB
followed by the tables they are contained within.
I am new and tried to normalize and do things correctly but have still
probably duplicated data unnecessarily.
Does anyone know if there is a way to get a list of fields across the entire
data base rather than by table, so I can review what I have done.

A member of the newsgroup, Mr. Dewey told me how to do what I want but I
could not follow his suggestion (my fault I'm sure).
Any help would be appreciated.
Greg
 
G

Greg

Jeff,
Thank you very much! I followed your procedures and placed my table and
field data into an Excel spreadsheet and could manipulate the information
just as I needed. What you created could be of use to many access beginners
such as myself.
Thank You, again,
Greg Jesky

PS: Thanks also to Tom Wickerath and Karl Dewey
 
J

Jeff Conrad

in message:
Jeff,
Thank you very much! I followed your procedures and placed my table and
field data into an Excel spreadsheet and could manipulate the information
just as I needed. What you created could be of use to many access beginners
such as myself.
Thank You, again,
Greg Jesky

PS: Thanks also to Tom Wickerath and Karl Dewey
Click to expand...

Cool, that is good to hear Greg.
Glad you found my add-in useful in your projects.

BTW, welcome to the Collective.....
...he....he....he...
 
Top