Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Feb 2008
    Location
    United Kingdom
    Posts
    490
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Any tips on code cleanup (MSACCESS2003)

    I have inherited an access database that is full of vb code. Looking through it I see lots of duplicated event code which could be wrapped up into common procedures. Is there any automated / assisted way of rounding up common code which can then can be put into common procedures.

    In the database there are reams and reams of duplicted code, its so wasteful and lazy. Thanks

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

    Re: Any tips on code cleanup (MSACCESS2003)

    There are tools that help you analyze your code, such as Total Access Analyzer, but I don't think you can automate the cleanup process - you'll have to do it manually.

  3. #3
    4 Star Lounger
    Join Date
    Feb 2008
    Location
    United Kingdom
    Posts
    490
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Any tips on code cleanup (MSACCESS2003)

    Thanks Hans. I had a look at the product but left quickly when looking at prices.
    I was hoping there may have been a magic way to export each line into a database and then group up duplicates, but that was wishful thinking.

    It's going to take hours manually, but if thats the only way thats it I will have to do it. Best regards

Posting Permissions

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