General discussion

Locked

How do I track an Access database

By TexasProud ·
I have an Access database that I inherited. It is comprised of 30 Tables, 285 queries, 45 macros, and 30 modules. It works within itself, but also gathers data from at least 5 other tables and databases. I do not want to have go through the queries and code line by line. Is there a program or way to trace and track the flow besides the analysis tool. I found that it was not really all that helpful. I have tried Visio 2000 but it just wanted to convert the database into shapes and draw thereleationships. I really need to know what it is doing and exactly where all it is gathering information from. The guy who wtore it is no longer with us and cannont be tracked down to ask.

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

How do I track an Access database

by Raffi_ In reply to How do I track an Access ...

Hello.

What you want to do is reverse-engineer the processes (Business Rules) taking place inside your DB. Sorry - can't be done.

The best you can hope for is to use a reverse engineering tool (several listed below) to turn your DB into a Logical Data Model (LDM) and Physical Data Model (PDM). From there you can infer (or guess) the initial rules used to design the thing.

Personally, I would run as fast and as far as possible from a project like that that has NO documentation.

http://www.embarcadero.com
http://www.microtool.de/case40/en/index.htm
http://manuals.sybase.com/onlinebooks/group-pd/pdd0800e/daug/@Generic__BookTextView/18316

Not a reverse engineering product but very cool
http://www.mks.com/campaigns/googleMSProject.jsp

Collapse -

How do I track an Access database

by TexasProud In reply to How do I track an Access ...

Thank you very much, I appreciate your help on this. I was afraid that was what the answer would be. However, one never knows for sure until one asks. Thank you again.

Collapse -

How do I track an Access database

by david In reply to How do I track an Access ...

I would have to agree with the previous answer - run as fast and as far as you can, before they catch you! As a consultant, having many spaghetti code projects to unravel, have found ? unless fixing one, and only one problem, inevitably it becomes quicker, cheaper, and easier to restart the project from the beginning. Even then, it is never simple nor trivial to do.

Consider presenting management with the opportunity to reengineer the program including enhancements and wonderful new bells and whistles ? such as user / techie documents.

Collapse -

How do I track an Access database

by TexasProud In reply to How do I track an Access ...

Poster rated this answer

Collapse -

How do I track an Access database

by TexasProud In reply to How do I track an Access ...

This question was closed by the author

Back to Desktop Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums