jt******@gmail.com wrote:
How can I take an existing Access database and document its structure?
I want to show fields, relationships, and indexes so that a real DBA
could recreate the database from scratch.
You know its true that Access has built in documentation. And there are
software options that will read the tables and regurgitate the table and
field defs. But depending on your objective, I don't find documentation
on paper of information you could easily get by opening a copy of the
Access database to be very valuable. I would prefer a copy of the
database and Access software and be able to view whatever I want. And
yes "real DBAs" look down on Access, but if challenged, I would guess
they could open an access database long enough to extract the database
table & field definitions.
If your objective is to upsize it to SQL server, Microsoft has tools for
that.
If your objective is to document to help another person maintain the
application, I believe that documentation of Modules is important -
explanations of what they do and comments in the code. Also
documentation of code behind forms can also be very helpful. Also
helpful is techniques used that may not be immediately obvious;
conventions used, etc. Unfortunately these are things you can't automate.
Bob