472,328 Members | 2,039 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,328 software developers and data experts.

Database structure documentation

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.

Nov 13 '05 #1
4 9841
The easiest way is to use Access' built in methods. Open the database,
select Tools | Analyze | Documenter.

Hope this helps

David Hodgkins, MCSD, MCDBA, MCSE
JSTAR Software Solutions
4402 Sweet Cherry Ln.
Kalamazoo, MI 49004
www.jstarsoftware.com - Home of AutoCompact for Access Databases
269-382-2931
<jt******@gmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
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.

Nov 13 '05 #2
I was hoping for something easy, like a third part tool that wouldn't
break the budget.

I had no idea that it would be that easy (or cheap).

I'm sitting here grinning at the quick and free solution.

John

Nov 13 '05 #3
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
Nov 13 '05 #4
On Wed, 06 Apr 2005 11:19:52 -0500, Bob Alston
<tu****************@cox.net> wrote:
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.


Indeed. Most of the "real DBA's" I have known over the last 25 years
have been pompous, self-infatuated jerks. Geeks with few redeeming
social graces and few rationally justified opinions about systems they
don't know.
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


Nov 13 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: kjphipps_377 | last post by:
Hi all! I have an application that needs to copy the database structure from one database to another without using the "Generate SQL Script"...
5
by: Hassan Naqvi | last post by:
Hi, Basically, I am Java developer. In past I have played with Oracle using Java (JDBC). But this is the time to play with IBM DB2 using Java...
5
by: Pato Secruza | last post by:
How can I print the database structure, including non default variables like Requiered, FieldSize, and most important DESCRIPTION. I want a table...
5
by: Paul H | last post by:
How do you folks get a reliable and complete brief of what is required before development starts? I am forever going back to a client once a...
9
by: Hugo Amselschlag | last post by:
Hi there, I've implemented a local system hook to suppress certain windows beeing displayed by the axWebbrowser control. Now I need some more...
7
by: Dan | last post by:
(Using Classic ASP & MS Access) I have a page that has 120 fields on it (mostly checkboxes). I cannot split this into smaller pages. So what i...
25
by: Colin McKinnon | last post by:
Hi all, There's lots of DB abstraction layers out there, but a quick look around them hasn't turned up anything which seems to met my...
1
by: Eric Sadoyama | last post by:
I have a database documentation question, but I am not even sure how to phrase it properly so I don't know where to start looking for answers. ...
1
by: | last post by:
Hi. This is a a semi-newbie question about how to store arbitrary information about my apps such that I can code quickly, mimizing complexity and...
0
by: tammygombez | last post by:
Hey fellow JavaFX developers, I'm currently working on a project that involves using a ComboBox in JavaFX, and I've run into a bit of an issue....
0
by: tammygombez | last post by:
Hey everyone! I've been researching gaming laptops lately, and I must say, they can get pretty expensive. However, I've come across some great...
0
by: concettolabs | last post by:
In today's business world, businesses are increasingly turning to PowerApps to develop custom business applications. PowerApps is a powerful tool...
0
by: teenabhardwaj | last post by:
How would one discover a valid source for learning news, comfort, and help for engineering designs? Covering through piles of books takes a lot of...
0
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...
0
by: CD Tom | last post by:
This only shows up in access runtime. When a user select a report from my report menu when they close the report they get a menu I've called Add-ins...
0
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...
1
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...
0
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.