Documentation

[Guest]

Anybody know of an easy way to show all relationships - a troubleshooting
"map" if you will - for tables, queries, forms, and reports? to show how the
entire package fits together?

I know there are plenty of ways to show table relationships and I know about
the documenter and the Object Dependencies, but wanted a more visual
"picture" of how it all fits together

 

[Douglas J. Steele]

See whether Total Access Analyzer has what you're looking for
http://www.fmsinc.com/products/analyzer/index.html

 

[Guest]

It's close - but I don't want to spend $300 on something when I'm converting
to 2007 - that it does not support. Any other suggestions???--
Thank you,

 

[John W. Vinson]

It's close - but I don't want to spend $300 on something when I'm converting
to 2007 - that it does not support. Any other suggestions???--
Thank you,

There are some other options at

http://www.accessmvp.com/JConrad/accessjunkie/doctable.html

John W. Vinson [MVP]

 

[Guest]

Thank you - I have used some of those tools (very nice, by the way)but I'm
looking for a visual representation of all object links, not just tables.
I've tried manually doing it in Visio, but it gets really messy, really fast.
Not to mention the hours it will take me to this manually and I'm at the end
of a contract, so time is of the essence. It has been requested and I just
can't believe it isn't out there somewhere - I'm an individual, not a company
so I'm trying to keep the cost down as well. Maybe that's the real problem -
?

 

[Guest]

One way to keep costs down is to invest in tools that will help you do a
better job, in less time. Presumably this is not the only time you will be
working on an Access application for a customer. I recommend that you
seriously consider purchasing Total Access Analyzer. I'm not affiliated with
FMS in any way, but I have used their software products for the past five
years. Total Access Analyzer is worth every penny of it's cost, in my
opinion. How much is your time worth?


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Guest]

I understand the value but I don't see the 2007 version - I would be wasting
money buying the 2003 version - that is why I don't want to buy it - not
because I don't see the future value.

 

[Guest]

If you are in the Access consulting business, then you will very likely be
dealing with users who have all different versions of Access (97, 2000, 2002,
and 2003) for many years to come. Unless you are working strictly within a
company, the chances of every one of your clients using Access 2007, even
within the next two years, is very slim indeed.

Also, with all previous versions, FMS has provided an upgrade path that is
significantly discounted versus a new purchase. I can't speak for their plans
concerning Access 2007, but you could call their toll free sales support line
to try to ascertain what their plans are in this regard for future releases
of the product.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Douglas J. Steele]

There's no scheduled date yet for it at
http://www.fmsinc.com/products/version2007.asp