Results 1 to 6 of 6
  1. #1
    Join Date
    Jul 2003
    Location
    Australia
    Posts
    217

    Question Finding out the IMPACT of changing a Table -- Utility

    I have written a utility with MS Access --- this utility helps me to quickly understand the impact of changing a table structure.

    When given a table name, it tries to find out how many references are there in the VBA codes. It reports all the procedures or functions which contain references. You may also select an individual procedure and then look at all the references in that procedure.

    It also reports what type of statement each one is, e.g.
    it might be referenced in a OpenRecordset statement OR
    referenced in an aggregate function OR
    referenced in RunSQL statement, etc.
    It also shows a pie chart of the % of the statement types.


    *** Hey guys ! I need your input ***
    >> Do you think this is enough ?
    >> What else can I add to this utility ?
    >> What needs to be changed ?

  2. #2
    Join Date
    Dec 2003
    Location
    Canada
    Posts
    710
    Sounds like an interesting utility. The impact on code caused by adding or altering a column would be nice to measure. I like the idea of presenting an impact chart to my boss when he asks for a change. I would also like to determine the impact on forms and reports. What and how many forms and reports are affected.

    Have you posted this in the MS Access forum?
    Last edited by certus; 01-13-04 at 18:11.

  3. #3
    Join Date
    Jul 2003
    Location
    Australia
    Posts
    217

    Smile

    Certus, you are the man I'm looking for.

    Currently, my utility do searches in form modules and standard modules only. Later, I shall extend it to report modules also.

    My utility is able to filter out all the table references. It can differentiate table references from non-table references, such as form references, report references, etc.

    My utility does display a pie chart as part of the result.

    Now could you tell me :

    (1) How do you want the Impact Chart to look like ?

    (2) What information do you want to be shown in the Impact Chart ?

    (3) How detailed should the information be ?

  4. #4
    Join Date
    Dec 2003
    Location
    Canada
    Posts
    710
    I definitely want to know not just the impacted but the non-impacted values on the chart. Then I really know the percentage of impact.

    I want to be able to drill down. Let me switch between listing and graphical view. Decide which (bar, line or pie) is the best communicator. Show me just the impact/non-impact overall and then determine the impact breakdown by reference type. Then show me listings of the references. Let me look at it from as many valuable angles as possible.

  5. #5
    Join Date
    Jul 2003
    Location
    Australia
    Posts
    217

    Post

    <I definitely want to know not just the impacted but the non-impacted values on the chart. Then I really know the percentage of impact.
    >>This can be done, but is going to take much time.
    But tell me, why you need to know the Non-Impacted values too ??


    <Decide which (bar, line or pie) is the best communicator.
    >>This sounds sophisticated.
    Overall, your requirements are challenging. What you have in mind is a really professional tool.

  6. #6
    Join Date
    Jul 2003
    Location
    Australia
    Posts
    217
    It will be available soon ... for download ...

Posting Permissions

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