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.
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.
9 1718
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.
NeoPa 32,556
Expert Mod 16PB
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.
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.
Thanks Seth and neopa. Sorry been away for vacation. Thanks will check it out tomorrow morning. :)
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.
NeoPa 32,556
Expert Mod 16PB
Generally, you can get a great deal out of analysing it with MS Word if you save it in RTF format.
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. :)
NeoPa 32,556
Expert Mod 16PB
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 ;-)
NeoPa 32,556
Expert Mod 16PB
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.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: DraguVaso |
last post by:
Hi,
I'm ne to this subject, and has been looking around for some software that
does the Object-Relational-Mapping, and generates the Data Access Layer. I
found alreaddy a lot of application that...
|
by: Michael |
last post by:
Hi everyone :)
I have a split database with the backend on a shared folder which
users access through the LAN. The front end sits on their hard
drives.
Apparently windows 2000 has a limit of...
|
by: temp |
last post by:
Hi,
My boss is asking me to generate a column mapping report of all the
queries. Basically, we get our data from ORACLE. There's a queary that
create new table from ORACLE tables. Then, there...
|
by: =?Utf-8?B?RGF2ZQ==?= |
last post by:
I am actually trying to get the UNC path of the main module of a process
running from a mapped drive, and I am trying to do this from a service. The
ProcessModule class only provides the full path...
|
by: zgh1970 |
last post by:
Hi, Friiends,
I am db2 UDB DBA on aix.
nickname to access the tables on db2/390. For the security ,we can use
user mapping for for the federation serse.
All the setting federation server,nickname...
|
by: koliver |
last post by:
Can anyone provide me with information on linking an Access database
with GPS mapping software
|
by: spdas |
last post by:
Aloha, I don't what it is called but I want to make a floor plan or
map of say 400 storage units.
I have done this before with "Stationary" storage units by creating
text boxes on a form page and...
|
by: EricEAS |
last post by:
Hi.
I am fairly new at Access and used to use Lotus Approach. There was one function in Approach I used to find very useful and I can't seem to find it in Access.
It is to do with importing...
|
by: alan |
last post by:
Hello world, I'm wondering if it's possible to implement some sort of
class/object that can perform mapping from class types to strings?
I will know the class type at compile time, like so:...
|
by: Damir |
last post by:
Hello,
I have a strange problem with federated access between two DB2 databases,
both on AIX 5, both instances V9.1 (FP02).
For the sake of this post, the two DB2 databases are named:
1. "live"...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
| |