Results 1 to 5 of 5
  1. #1
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Tracking Changes in DB Design (2000)

    Total Access Detective is what you are looking for. It's powerful, but it is not cheap.
    I use it for years and are very pleased with this and other FMS products.
    Francois

  2. #2
    New Lounger
    Join Date
    May 2002
    Posts
    21
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Tracking Changes in DB Design (2000)

    Thanks very much, Francois. I will check it out. Are you pleased with the way it reports changes in VBA code?

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

    Re: Tracking Changes in DB Design (2000)

    Visual Source Safe is the tool we use in the office. If you have Office Developer or VB Pro, VSS comes with it. It requires you to check objects in and out but gives you the ability to compare each checked in version of an object (forms, reports, macros, modules, queries) against earlier versions and even to roll back to an earlier version of an object if you've painted yourself into a corner. You can also share objects between projects, which means if you change the code or design in source safe in one project, the other projects also reflect the change.

    If all you want is reporting, then the FMS tool is probably adequate. If you want control over the design, look into VSS.
    Charlotte

  4. #4
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Tracking Changes in DB Design (2000)

    Send me a mail (see my profile) and I'll send you some samples of the most important reports. What do you prefer: PDF or Snapshot format ?
    Francois

  5. #5
    New Lounger
    Join Date
    May 2002
    Posts
    21
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Tracking Changes in DB Design (2000)

    Does anyone know if there is a tool available to take 2 DB's ("old" and "new") and report on DESIGN changes that have been made in "new"? IE: List inserted or deleted tables, colums, forms, controls w/i forms .... you get the idea. I'm NOT concerned with tracking data changes. Thanks.

Posting Permissions

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