Doctor said:
Does anyone know if the resources on the below posted site are good. Maybe
you have some experience with this group or could offer some feedback on
the
value of them? Most of the time I can figure out what code is doing and
modify it to do what I need, but I struggle to create my own from scratch.
Would this help?
I've used their Code Tools and found it useful. I now use a free-download
product from MZTools,
http://www.mztools.com, for the same purposes and like
it just as well.
In the Access 97 timeframe, I tried SourceBook and was not nearly so pleased
with it -- I found it took as long to understand how to use much of their
code as it would have taken me to write and test my own, and in a few cases,
the code was inadequately tested and let some errors "fall through the
cracks". I did not attempt to review the whole product to see if that was
"more than a few" because I had real work to do and no time to waste doing
QA on Source Book.
My experiences with Total Access Analyzer were "spotty" at best. They still
sold the Access 2.0 version when we were working on Y2K remediation of a
client's Access 2.0 database; the volume of data just overwhelmed TAA and it
locked up. But, even though it was a product on their current "for sale"
list, they were not doing defect correction any more. One of my co-workers
had to create queries (which, by the way, he was able to do handily, without
them being overwhelmed or locking up) to do what TAA could not do and what
FMS was unwilling or unable to correct.
I had, and suspect I still would have, some difficulties with their
licensing provisions in cases where a prime contractor licenses the product,
and has different subcontractors in and out to use it.
Larry Linson
Microsoft Office Access MVP