Graphical DB Viewer?

H

Henrootje

I have a database with a lot of tables, queries and so on.
I need to analyse this thing.

What I need is a graphical presentation of all the tables, queries (and
preferably forms and reports too) so that I can easily see which query
is linked to which table/query.

(which query is based on what other query/table?)

I imagine the tables at the bottom, the queries above the tables and
lines connecting them to present the dependancies between them.

Is there a tool available that can do this (or this sort of thing?) I
started doing this by hand but there are 40something tables and 96
queries :s

TIA Henro
 
T

Tom Wickerath

Hi Henro,

Yes, there is such a tool. It is called Total Access Analyzer, and is
marketed by FMS. This tool is very much worth it's cost in my opinion. It
will do what you want, and a whole lot more.

http://www.fmsinc.com/products/analyzer/index.html


Tom

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

:

I have a database with a lot of tables, queries and so on.
I need to analyse this thing.

What I need is a graphical presentation of all the tables, queries (and
preferably forms and reports too) so that I can easily see which query
is linked to which table/query.

(which query is based on what other query/table?)

I imagine the tables at the bottom, the queries above the tables and
lines connecting them to present the dependancies between them.

Is there a tool available that can do this (or this sort of thing?) I
started doing this by hand but there are 40something tables and 96
queries :s

TIA Henro
 
H

Henrootje

I do like that tool very much but my boss does not like the price :s
I think it is very good but the ones deciding on budget see a lot more
functions then I asked for....... :(
Is there s'thing cheaper or maybe even free??


TIA Henro
 
T

Tom Wickerath

Hi Henro,
Is there s'thing cheaper or maybe even free??
Click to expand...

Not that I'm aware of. You simply didn't ask for enough! Tell em you need to
be able to easily pinpoint errors and performance bottlenecks that are
usually always present in databases built by others. A single user license is
$299. This amount can be tallied up in a big hurry by an employer who is
paying an hourly wage plus any benefits (bene's such as sick leave, vacation,
holidays, etc. can typically be 1/3 of a person's hourly salary).


Tom

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

:

I do like that tool very much but my boss does not like the price :s
I think it is very good but the ones deciding on budget see a lot more
functions then I asked for....... :(
Is there s'thing cheaper or maybe even free??


TIA Henro
 
A

Albert D.Kallal

There is the tables ER diagram (Entity Relationship).

That is the so called "relationship window". That will graphically show all
your tables, and also show the relationships between the tables..

tools->relationships

If the tables are not displayed..then use the relationship menu->show table,
and place the tables graphically on the display. You can then print this
after.

Note also that you can "right click" on any table in this graphical
view..and jump to design mode. This is certainly my favorite #1
tool....especially when looking at an application that is not mine.

The real problem with showing that what forms uses what query is that often
this occurs in code.

strBuf = "qryTest"

me.RecordSource = strBuf

In the above, I just set the forms query to qryTest..and the ONLY way to
discover this is to actually run the code. So, showing all relationships
between objects is not really possible unless you actually run and interpret
all the code.

As a side note, ms-access 2003 does have a feature that if you right click
on a query, or form, or report, you can "view" dependences. (it does it best
job to show dependencies...despite the above code problem (which would
obviously not show the current form is depending on qryTest).

Also, don't forget the tools->analyze->documenter

(the above can printout all code, queries, table designs)

Also, if you have not yet..I STRONGLY suggest you grab the mztools here:

http://www.mztools.com/

These tools are nice for your own code, but when jumping into others
code...it is INVALUABLE. Of course, when you are in the code editor, we all
know that placing your cursor on a sub (or function name), and hitting
shift-f2 will "jump" you to that routine. If you hit ctrl-shift-f2...you
un-cork back the way you came. This effectively allows you to "ski" through
your code...jumping from code calls to code calls.

.. However, the mztools will actually TELL YOU what OTHER routines
use the CURRENT routine you are in. So, you an instantly view all dependant
code routines that call the current routine you are in. This is simply a
must have when diving into uncharted territories called "other peoples
code!!"

good luck...and grab the mztools...as they are life saver when looking at
other peoples code....
 
H

Henrootje

Just to let y'all know: my chief heartidly approved buying the total
Access Analyzer
 
Top