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

    Question Unanswered: 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
    Nov 2003
    Location
    Plymouth, UK
    Posts
    59
    Could you post it uop for down load, I could check to see if it works correctly on my system!!

    If you want!

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

Posting Permissions

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