By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,478 Members | 1,833 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,478 IT Pros & Developers. It's quick & easy.

Documentation of database

P: n/a

I have developed a database which is much bigger than I thought on the
beginning.

Tables: 80
Queries:250

Unfortunately,I was developing the database for 1 and half year and
without any proper documentation.

Is there any possibility how to automaticly download list of tables and
queries into MS Excel?
If yes ,can it be done in more sophisticated way,using also fields in
tables or in queries identification of which queries or tables are used
as source or which further queries are using this query as their source?

Generaly speaking,I am wandering how shall I develop documentation for
database (process and final outcome).

I would be very much thankfull for any help.

Oskar


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 13 '05 #1
Share this Question
Share on Google+
8 Replies


P: n/a
oskar hritz <os*********@sca.com> wrote:
Is there any possibility how to automaticly download list of tables and
queries into MS Excel?


Don't think so, but have you tried Tools/Analyse/Documenter (A97)?

I asked this very question on here a while back and the answer, quite
correctly when you think about it, is that you should document your design
*before* you go to work on Access. Doing it after the fact is nigh on
impossible.
Nov 13 '05 #2

P: n/a
Create a report, base the recordsource on the mysysobjects table limiting
the type to 1 or 5

rh

"oskar hritz" <os*********@sca.com> wrote in message
news:41*********************@news.newsgroups.ws...

I have developed a database which is much bigger than I thought on the
beginning.

Tables: 80
Queries:250

Unfortunately,I was developing the database for 1 and half year and
without any proper documentation.

Is there any possibility how to automaticly download list of tables and
queries into MS Excel?
If yes ,can it be done in more sophisticated way,using also fields in
tables or in queries identification of which queries or tables are used
as source or which further queries are using this query as their source?

Generaly speaking,I am wandering how shall I develop documentation for
database (process and final outcome).

I would be very much thankfull for any help.

Oskar


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 13 '05 #3

P: n/a
Keith Wilby <ke*********@AwayWithYerCrap.com> wrote:
I asked this very question on here a while back and the answer, quite
correctly when you think about it, is that you should document your design
*before* you go to work on Access. Doing it after the fact is nigh on
impossible.


Nah, that would take the fun out of it <smile> Seriously though so much of the time
the users don't have a clue what they want. I work on the principle of a little
chatting, throw together a few screens, more chatting and repeat.

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
Nov 13 '05 #4

P: n/a
Tony Toews <tt****@telusplanet.net> wrote:
so much of the time
the users don't have a clue what they want. I work on the principle of
a little chatting, throw together a few screens, more chatting and
repeat.


Can't argue with that! And they usually try to get far to involved with the
design, "Oh can we have a lookup table for so and so ...", a bit like
wanting to have a say in the design of their new car's gearbox.
:o)
Nov 13 '05 #5

P: n/a
Having recently moved from the automotive retail sector, you'd be
surprised how many people try to do things like that.....

"i'd like to put my car in for a service. The brakes don't feel quite
right. I heard that the new [insert car name here] has a special new
braking system. Why doesn't my car have one, i'd like one".....

yes, of course, we'll contact the manufacturer of your vehicle and ask
them to amend their multi million pound r&d process so that someone who
bought a 15k car and then read an article in 'What? Car' is happy.

With databases, i've found that even if you document everything, and get
user buy-in right up to the last minute, by the time you publish it
there are 2 dozen things they wanted but your mind-reading skills were
unable to devine........

-------------

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 13 '05 #6

P: n/a
Northern Monkey <No************@FatLad.com> wrote:
i've found that even if you document everything, and get
user buy-in right up to the last minute, by the time you publish it
there are 2 dozen things they wanted but your mind-reading skills were
unable to devine.


Quite so, but getting them to sign up to a statement of user requirements
means that any deviation or addition whch requires re-work can be charged
extra for.
Nov 13 '05 #7

P: n/a
Which is all good for a contractor, but an internal person gets blamed
for not having PSI, and is sent scurrying back to his little office to
make yet more virtually useless modifications. Not that i'm bitter, or
anything.........

-------------

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 13 '05 #8

P: n/a
Northern Monkey <No************@FatLad.com> wrote:
With databases, i've found that even if you document everything, and get
user buy-in right up to the last minute, by the time you publish it
there are 2 dozen things they wanted but your mind-reading skills were
unable to devine........


They pay me by the hour. <shrug>

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
Nov 13 '05 #9

This discussion thread is closed

Replies have been disabled for this discussion.