Results 1 to 10 of 10
  1. #1
    Join Date
    Feb 2008
    Posts
    4

    Unanswered: Bug tracking solution

    Hi,

    I'm looking for a bug/issue tracking solution done entirely in MS Access. Does such a thing exist?

    My requirements are that it must need only Access, and be accessible in a shared environment solely by opening a .mdb file from a shared folder. It must support various issue lifecycle related things, and the stuff those tracking systems do in general.

    It may or may not be commercial software.

    If anyone knows of such an available solution, please let me know.

    (And yes, I've searched on Google, and haven't found anything worthwile, so that's why I'm asking here now.)

    thx

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59

  3. #3
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Shouldn't be too hard to create your own if no "off the shelf" ones exist that match your needs.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  4. #4
    Join Date
    Feb 2008
    Posts
    4
    Yes, it IS hard. The case is that we already have one home-brew tool for that, but it's too basic, and required already too much work in itself. A nice fleshed-out solution requires considerable attention and development time. That's why we are looking for one that is specifically prepared as a solution, not just as a side product of development of some totally different kind.

    You know, that's why people in general choose stock software instead of doing their own (:

    My real problem is that I have the constraints stated above (I really do), so no ready solutions I've found so far qualify.

  5. #5
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    You know, that's why people in general choose stock software instead of doing their own (:
    HA! In my experience, people generally choose custom software instead of "stock" software :P

    Side effect of my career I guess ^^
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  6. #6
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    I just uploaded a Bug Tracking program I wrote a few years back into the code bank here: http://www.dbforums.com/showpost.php...2&postcount=61

    I hope you find it useful. Modify it as you wish. It's got lots of goodies but if it's not what you're looking for, it should at least get you started.

    If you decide to use it, the requirements are that you send me some feedback on it.
    Last edited by pkstormy; 02-14-08 at 10:31.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  7. #7
    Join Date
    Feb 2008
    Posts
    4
    Whow, thanks, that looks very promising, while I haven't fully discovered it yet. A few questions that arose while having a glance at it.

    Does it have, or have you considered some sort of issue history tracking? I mean, the ability to overview what changes have been applied to a specific issue, and when?

    Is there a way to add comments to issues with username and timestamp automatically, instead of simply appending text to a single comment field?

    Can attachments be added to issues?

    Can it notify specific users by email when an issue is updated? Can users add themselves to a given issue's notify list by simply adding their email?

    I don't want to seem too demanding, but those features would be really handy - while I realize that your solution is the most complete offer so far (: Of course, if we choose to employ it, we'll provide feedback.

  8. #8
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    I think if you want those features then perhaps you could add them yourself.....

    and then post the code back here

  9. #9
    Join Date
    Feb 2008
    Posts
    4
    Sure. However, I thought it best to first ask the original dev, especially given that he asked for feedback.

  10. #10
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    They definately could be added to the program. It's a 2 year old program I developed for a company. I'm not really planning on updating it since I'm no longer with that company but feel free to update and expand on it as much as you wish. You can probably update several items. Use some of the techniques already in the program to embed new ones. For example, you can add the automatic emailing part by looking at the code which already emails (or download some examples on emailing from the code bank). It took me about a week to develop it so it was done fairly quickly. I apologize I didn't fully comment the code but it's fairly easy to figure out what the code does. I tried not to use too many complicated routines. Again, just give me feedback on how it works for you after using it for a while but feel totally free to upgrade it to make it do the things you want it to do. I think it also already does some of the things you mentioned but I haven't looked at it extensively for quite a while. Since I'm giving it out free, I apologize that I'm not actively supporting or updating it but I'm more than willing to help you out on any errors you may get while using it. It's been pretty well tested so to the best of my knowledge, it's error free.

    There are also many other example mdb's in the code bank where you can possibly add any features you like from those examples to this one.
    Last edited by pkstormy; 02-15-08 at 15:08.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Posting Permissions

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