473,729 Members | 2,108 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 9934
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.goo glegroups.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
documentatio n 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
2318
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" function in Enterprise Manager. I'd like to do this from within a stored procedure. Can someone recommend the best approach for this? I've seen references to using SQL-DMO from a stored procedure using the sp_OA* procs in other postings to this group but was wondering if there was an easier way?...
5
14716
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 (JDBC). So kindly help this DB2 newbie. I have a file of 32 MB, named as "fdbk5.0". This is actually a database created in DB2 and containing records. I am interested in viewing the *structure of this database, i.e. table names, column names and finally all the records. How I can do this? Which...
5
7737
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 like this: ----------------------------------------------- | Name | Type | Size | Required | Description | ----------------------------------------------- | ... | ... | ... | ... | ... |
5
2217
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 project has started saying "Hang on, now that I've started building this I realise what you want is impossible, we'll have to do this way instead....etc.." OK, so this is partly down to me not getting all the facts from day one, but if the client does not give detailed, accurate instructions there...
9
5675
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 information before I can decide, whether to suppress a window or not. My callback function get a long pointer (lParam) to a structure which contains further information. This structure is described at MSN as follows: typedef struct tagCREATESTRUCT {
7
2027
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 want to do is write a class that handles this. in the code it would be something like: Set thisForm = new classBigForm
25
2560
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 requirements. Before I go off and write one I thought I'd ask here if anyone knows of such a beast... I want some code where I present an array of data, and the corresponding primary key and let the code work out whether to INSERT or UPDATE it, I also want to be able to present the data from a QBF or...
1
2302
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. We are developing a database that is based on several different data standards and schema. I'm finding it confusing to keep it all straight. What's this field for? Which standards document is it based on? What are the permitted values? Which business rule governs it? In theory, we do have all...
1
1286
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 the number of things I have to hold in my brain. I am going to describe the scheme I'm using, and then I'm going to describe another scheme that may be more OO but that I have not tried. I'm hoping someone vastly smarter and more experienced than me will critique this and/or tell me a yet...
0
8931
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8767
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
1
9221
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9162
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8165
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
4536
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
3246
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2701
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2171
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.