Need a way to Document a Database

  • Thread starter Thread starter mmadani
  • Start date Start date
M

mmadani

The embedded access documenter bombs out for some reason. I have around 244
tables in the back end, and around 50 in the front end.

I need to get a listing and file type, and relationship for each, and also

I need to get a database Schema Diagram , but it is not happening. Is there
a freebie or a third party tool or utility to do that.

Any help will be greatly appreciated.

M
 
If you want to use the Access tool, try splitting up what
is documented all at once into different docuements. As
for a database schema, I have used Visio to "reverse
engineer" and ODBC datasource such as Access. Basically
you create a new Database diagrams and there is a utility
to reverse engineer a database. Be sure to select the
correct driver (Access 9.0 or what-have-you).
 
I happily use AccessAnalyzer ( www.fmsinc.com ). It isn't free (although I
think they offer a crippled trial version) but it is easily worth it's
weight in gold to me in terms of the time saved and the wealth of
information it can provide.

I especially appreciate being able to have a report showing query
inter-relationships and dependencies, even if the query is used inside of
VBA code (as long as it's identified as a qdf in the code and not as just a
string). Being able to make a change and being confident that you've
checked out the ramifications in all known dependencies is a slice of heaven
(yeah, I know, I need to get out more). Conversely, being able to tell a
supervisor or client, with just a glance, just how much work would be
involved in making a "simple" modification is nice too.

Hope this helps,
 
Do you know of a cheaper (or free) tool that will show query inter-relationships

Thanks in advance.
 
No, I don't. Sorry.

However, that doesn't mean that there isn't one, since I simply haven't been
looking. :-)

Good Luck
(and if you find one, let me know)
 
Back
Top