Page 1 of 2 12 LastLast
Results 1 to 15 of 19
  1. #1
    5 Star Lounger
    Join Date
    Oct 2001
    Location
    San Bernardino, California, USA
    Posts
    734
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Developer Utilities? (XP, 2000)

    I realize I have been making some serious errors in the DBs I have developed by not following any naming conventions and by including spaces and special characters (# /) in field names. Fortunately, none of these have been fatal but I want to start cleaning up my work and try to be more disciplined.

    Problem is, I have hundreds (thousands?) of fields, forms, tables, & VBA lines of code. Are there utilities that can do a global find and replace? How about a utility that can look at my DBs and identify objects that are not used anywhere?

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

    Re: Developer Utilities? (XP, 2000)

    Rick Fisher and Black Moshannon have find and replace utilities for Access. You can download both for trial; full functionality requires purchase.

    FMS has a series of utilities for Access, such as Total Access Analyzer.

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

    Re: Developer Utilities? (XP, 2000)

    Also take a look at MZ-Tools, which includes a Code Review tools that will show you a list of unused object, routines, variables, etc., as well as having some other handy utilities in it.
    Charlotte

  4. #4
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Developer Utilities? (XP, 2000)

    Is there a utility that shows unused forms, queries and reports?
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

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

    Re: Developer Utilities? (XP, 2000)

    I think Total Access Analyzer will do that (I don't use it myself). Not cheap though, at US$ 299.

  6. #6
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Developer Utilities? (XP, 2000)

    What do you use --- or are you supernaturally organized? <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

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

    Re: Developer Utilities? (XP, 2000)

    The latter, of course <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15>

    Well, I am rather, eh, fanatic about things like that. I keep track of what I use database objects for in my notes. Sometimes I will keep an unused object in a database during development because I might need it later on, but I'll make a note of it. Before delivering the (more or less) final version, I'll go through my notes and remove things I don't need any more (I'll keep a backup copy of the development version, of course)

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

    Re: Developer Utilities? (XP, 2000)

    Total Access Detective from FMS, Inc., will do it, but I dislike the product. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    Charlotte

  9. #9
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Developer Utilities? (XP, 2000)

    Care to share the reason?
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

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

    Re: Developer Utilities? (XP, 2000)

    I found the interface hard to work with. Basically, I didn't think the results were worth the effort it took to get them. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15> Plus, the copy installed on my machine went sideways for some unknown reason, and I just never bothered to untangle it.
    Charlotte

  11. #11
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Developer Utilities? (XP, 2000)

    Good enough. So are you as supernaturally organized as Hans? Or do you have a different system you'd recommend. (I'm trying to avoid the finger grafts) <IMG SRC=http://www.wopr.com/S/evilgrin.gif alt="I'd be all thumbs"> .
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  12. #12
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Developer Utilities? (XP, 2000)

    Not that this will help you, but Access 2003 has some basic tools to help you in this area. Previously, we've used Total Access Analyzer, and found it quite useful. And you can also use Black Moshannon's Speed Ferret to effectively do this kind of thing as well. But being only average in the organization area, we use a trick to test and see if an object is still being used. When we think we want to delete something, we rename it with a zzz_ prefix and then let it sit there for a while before we actually delete it.
    Wendell

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

    Re: Developer Utilities? (XP, 2000)

    I try to keep that sort of stuff out in the first place. When I stop using something, I follow Wendell's approach, except I usually use a tilde to flag the objects and make them sort to the top of the list. Then, if something else complains, I know I still need the beast and change its name back to normal. If nothing else needs it, the last thing before release is to get rid of the deadwood. An alternative to renaming is to have a separate database and to export the object there. Then if something breaks, you can import it back in, but it saves you the step of removing the obsolete objects before shipping, and it gives you a fall back position.

    Since I work with Visual SourceSafe a lot, I can keep projects with objects like that in them. If I need them, I can just share them to my current project.
    Charlotte

  14. #14
    5 Star Lounger
    Join Date
    Jul 2004
    Location
    Ohio
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Developer Utilities? (XP, 2000)

    what does visual sourcesafe do?
    <img src=/w3timages/blueline.gif width=33% height=2>
    <big>John</big>

  15. #15
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Developer Utilities? (XP, 2000)

    Visual SourceSafe can be used with any VBA or VB development project, including Access databases. It is most useful when you have multiple developers working on a single project, as it lets you check out an object. Other developers are then made aware that the object is being worked on if they try to open it. You can also use it to archive the various stages of a development, so if you need to revert back because of problems, or an object get corrupted, you can replace it.
    Wendell

Page 1 of 2 12 LastLast

Posting Permissions

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