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

Mapping of the access

P: 13
Good afternoon,

I have an Access Database that I built and it has a huge size. But that is not a concern. The real question is, is there any possible way that the database could be mapped out on its own? Meaning is there anyway I could do to printout the map showing what has been connected to build the select, make, update, delete queries. sort of gives you a full story of the database with the sql narratives. The purpose for this, is to be able to pinpoint the rootcause and be able to correct it. A way to back track what you built. All I want to see is the relationships and SQL nothing else.
Dec 24 '11 #1

✓ answered by Seth Schrock

What version of Access do you have? I know that Access 2010 has the ability to do this using the Database Documenter. I can't remember what the name of the tab is, but it is right next to the Relationships button.

Share this Question
Share on Google+
9 Replies


Seth Schrock
Expert 2.5K+
P: 2,931
What version of Access do you have? I know that Access 2010 has the ability to do this using the Database Documenter. I can't remember what the name of the tab is, but it is right next to the Relationships button.
Dec 24 '11 #2

NeoPa
Expert Mod 15k+
P: 31,186
Spot on Seth. This feature has been available for many versions back to at least 2000. In earlier versions you invoke it from Access using Tools | Analyse | Documenter.
Dec 25 '11 #3

Seth Schrock
Expert 2.5K+
P: 2,931
Versions 2007 and 2010 have it on the Database Tools tab in the Analyze sections.

@NeoPa Thanks for that information. I didn't realize that it went back that far.
Dec 25 '11 #4

P: 13
Thanks Seth and neopa. Sorry been away for vacation. Thanks will check it out tomorrow morning. :)
Dec 26 '11 #5

Seth Schrock
Expert 2.5K+
P: 2,931
Just to let you know, if you plan on printing the report, just check the number of pages first. Even a simple database can be up to 75 pages.
Dec 26 '11 #6

NeoPa
Expert Mod 15k+
P: 31,186
Generally, you can get a great deal out of analysing it with MS Word if you save it in RTF format.
Dec 27 '11 #7

P: 13
Not too bad. I could deal with this. I did chose the relationship with the SQL for the Queries but it gave me all the SQL. Which is fine, I can work with it. The only thing is that it generated over 180 pages all because of the spaces.. I had to manually cut it down to 75 pages in Word Documents. Thanks, case is closed. :)
Dec 27 '11 #8

NeoPa
Expert Mod 15k+
P: 31,186
Glad that helped. We don't close topics as such, but if you select a Best Answer (Post #2 looks good for that), that indicates the thread is pretty well answered ;-)
Dec 27 '11 #9

NeoPa
Expert Mod 15k+
P: 31,186
I suspect you got the wrong post by mistake, as my post (#3) was only a clarification of the idea that had already been posted in post #2.

I'll reset it for you, but only you can set the Best Answer so may I suggest post #2 again.
Dec 28 '11 #10

Post your reply

Sign in to post your reply or Sign up for a free account.