Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    Jul 2001
    Location
    NJ, USA
    Posts
    617
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Total Access Analyzer (Access03)

    Would you recommend Total Access Analyzer? Is it straight forward to use. Thank you. Fay

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Total Access Analyzer (Access03)

    I don't use Total Access Analyzer, so I cannot comment on its use. I find the price of US$299 rather steep; on the other hand, if you're sure you will be using it intensively, it may well be worth it.

    (I use Find and Replace from Rick Fisher Consulting, which makes searching and replacing across all objects in a database very easy, and which can generate cross reference documentation for a database. At US$37, it is a lot cheaper)

  3. #3
    5 Star Lounger
    Join Date
    Jul 2001
    Location
    NJ, USA
    Posts
    617
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Total Access Analyzer (Access03)

    One of the big reasons I was looking at it is that it is suppose to find the unused objects in the database. I think I have a bunch of currently unused queries. Is there a cheaper product for that task? Fay

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Total Access Analyzer (Access03)

    I haven't used the product in 2003, but I didn't care for it in earlier versions and I have always felt it was overpriced for what it did. I would be very careful about so-called "unused objects", since they may not really be unused. The easiest way to discover this is to turn off any name autocorrect settings and then rename all the queries you think might be unused. Then start opening the queries, one at a time. That will let you know which ones are referenced in other queries, although they might not be used in code or in interface objects. Try to run the application and you'll start discovering the queries that are called in code or used in objects. It isn't as pretty as the FMS product and it takes time, but it's a whole bunch cheaper and at least as reliable.
    Charlotte

  5. #5
    5 Star Lounger
    Join Date
    Jul 2001
    Location
    NJ, USA
    Posts
    617
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Total Access Analyzer (Access03)

    Thanks to both of you. I will take your recommendations and save my money. Fay

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •