Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    May 2001
    Location
    MIA (takittodahous), Florida, USA
    Posts
    86
    Thanks
    0
    Thanked 0 Times in 0 Posts

    db compare (2002 SP-2)

    Hey all,

    Does anyone out there know of a good db comparison tool? I get a stock db from one of our vendors. I have a bunch of bells and whistles added in to our current version. These don't appear in the provided db and I'd like to import them - but I don't want to miss anything either.

    So I'd like to do a comparison of all the tables/queries/macros etc. in the two versions - maybe there's a tool out there you like?

    Lem'me know... THANKS!!

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

    Re: db compare (2002 SP-2)

    I don't have experience with any of the following, which I found using Google:
    Compare 98 from Ashish Systems
    CompareWiz and CompareDataWiz from Software Add-Ins
    Comparer from SourceBin
    There is also the well-known Total Access Detective from FMS Inc, but I haven't been able to reach their website recently (does anybody know if they have gone out of business?)

  3. #3
    Star Lounger
    Join Date
    May 2001
    Location
    MIA (takittodahous), Florida, USA
    Posts
    86
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: db compare (2002 SP-2)

    Thanks HansV!

    As always, you are a font of knowledge for my Access questions. <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23>

    I am familiar with FMS - I'll take a peek at the others too.

    Thanks again.

  4. #4
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: db compare (2002 SP-2)

    AFAIK, FMS hasn't gone out of business - I just got their latest monthly junk e-mail, and when I clicked the link their web site opened (see att'd pic). By some chance you aren't using a HOSTS file - a file used by Windows & IE that maps IP addresses to host names? If the host site changes the numerical IP address, any link to site will fail - not just existing shortcuts or links. I had this problem a while back, till discovered cause it seemed like all sorts of web sites had mysteriously gone out of business.... If this is applicable, see this MSKB article for explanation:

    Problems Using Internet Explorer with Incorrect Hosts File

    If this does not apply, then why FMS site is not accessible is a mystery....
    Attached Images Attached Images

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

    Re: db compare (2002 SP-2)

    Hi Mark,

    Thanks, it's a good tip, but I don't have a reference to the FMS site in my HOSTS file; I even renamed it for a short while to disable it, but that made no difference. But it's good news for the poster of this thread that FMS is still active. (IE starts to open the FMS website on my PC, but always times out. Never mind, ...)

Posting Permissions

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