Documenting Access 2003 Databases

[klew]

I am trying to document MS Access 2003 database but the Documenter is
limited. Is anyone using 3rd party software to document their db's?
If so, what you using and what are the pros and cons?

Thanks.

K

 

[Daniel Pineault]

Limited in what way. What are you looking to do exactly? You need to give
us some information on what you are looking to achieve if you want us to be
able to advise you.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.com/index.php
Please rate this post using the vote buttons if it was helpful.

 

[a a r o n . k e m p f]

SQL Server has lots of documentation tools.

maybe you should upsize to SQL Server!

-Aaron

 

[klew]

I am in a new position, taking over for an employee who created
numerous tables without documenting which queries were used, how they
related to other tables etc.

Essentially, I am looking for an all-in-one solution that will display
all queries and tables used to build other tables or in other words,
show me the path in how a table was created. I hope that makes
sense.

Thanks for everyone's time and effort in responding.

K

 

[Roger Carlson]

If you're up for buying a third party product, there's always FMS's Total
Access Analyzer. http://www.fmsinc.com/MicrosoftAccess/BestPractices.html

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[a a r o n . k e m p f]

take a class on SQL Server. and learn the system objects such as
syscolumns
sysobjects
sysindexes

or

sys.columns
sys.objects
sys.indexes

if you're hardcore

-Aaron

 

[Tony Toews [MVP]]

SQL Server has lots of documentation tools.

maybe you should upsize to SQL Server!

That's one of the weakest reasons for upgrading to SQL Server I've
ever read.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Larry Linson]

That's one of the weakest reasons for upgrading to SQL Server I've
ever read.

Tony

You're quoting Mr. Kempf again. <SIGH>

As I have only recently begun to see him quoted again after a period of
absence (?), I can only say that I hope Mr. Kempf enjoyed his vacation as
much as we did. I, for one, look forward to his enjoying another vacation in
the near future.

Larry

 

[a a r o n . k e m p f]

SQL Server has enterprise level tools.
SQL Server has these things called 'websites' where people share
knowledge and code snippets.

Access doesn't.

www.questsoftware.com
www.microsoft.com/sql
www.codeplex.com
www.sqlserverperformance.com
www.sqlservercentral.com
www.sqldts.com

http://www.google.com/search?hl=en&safe=off&q="Access+Documentation"
= 92,000 results
http://www.google.com/search?hl=en&safe=off&q="SQL+Server+Documentation"
= 670,000 results.

SQL Server has real tools to do stuff like this.
But the bottom line is that you don't need to buy or write a tool--
you just need to learn to use the existing tools.

Upsize everything to SQL Server and enjoy (free) enterprise level
tools.
Upsize everything to SQL Server and enjoy real system tables. (Access
has _NOTHING_ similiar to syscomments, specifically)



-Aaron

 

[a a r o n . k e m p f]

Likewise. I can't wait for another vacation.

Sorry that everyone on this newsgroups gangs up on me-- because I'm
right.

It doesn't justify 'mob tactics' that I have been a victim of.

-Aaron