Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

Compare two MDB or TABLES

Discussion in 'Information Technology' started by DREAMER, Jul 28, 2006.

  1. DREAMER

    DREAMER
    Expand Collapse
    Guest

    Hello Everybody!

    I need to compare two MDB or two TABLES in order to know what record are new, and what record were modified with respect to a previous MDB ....

    Thanks!!

    Dreamer.-
     
  2. Loading...


  3. Larry Linson

    Larry Linson
    Expand Collapse
    Guest

    "DREAMER" <LG@ARGENTINA.COM> wrote in message
    news:O7a$gAxnGHA.1332@TK2MSFTNGP05.phx.gbl...
    Hello Everybody!

    > I need to compare two MDB or two
    > TABLES in order to know what record
    > are new, and what record were modified
    > with respect to a previous MDB ....



    Link the Tables from one into the other, create queries joining the tables
    with outer joins and use the criteria Null for one... that will tell you
    Records that were added. Make the join the other way, and use the criteria
    Null under that field to tell which were deleted.

    It gets more complicated if you want to look for differences in the content
    of records. FMS, Inc. has a commercial compare software package -- you can
    check their website, http://www.fmsinc.com, to see if it suits your needs
    and is in your price range. There may be freeware or shareware tools, but
    you'd need to Google for them, as I don't know where to suggest for this
    particular functionality.

    Larry Linson
    Microsoft Access MVP
     
  4. Dreamer

    Dreamer
    Expand Collapse
    Guest

    Thank you Larry!!

    "Larry Linson" <bouncer@localhost.not> escribió en el mensaje
    news:u3bwlDynGHA.4496@TK2MSFTNGP04.phx.gbl...
    >
    > "DREAMER" <LG@ARGENTINA.COM> wrote in message
    > news:O7a$gAxnGHA.1332@TK2MSFTNGP05.phx.gbl...
    > Hello Everybody!
    >
    > > I need to compare two MDB or two
    > > TABLES in order to know what record
    > > are new, and what record were modified
    > > with respect to a previous MDB ....

    >
    >
    > Link the Tables from one into the other, create queries joining the tables
    > with outer joins and use the criteria Null for one... that will tell you
    > Records that were added. Make the join the other way, and use the
    > criteria Null under that field to tell which were deleted.
    >
    > It gets more complicated if you want to look for differences in the
    > content of records. FMS, Inc. has a commercial compare software package --
    > you can check their website, http://www.fmsinc.com, to see if it suits
    > your needs and is in your price range. There may be freeware or shareware
    > tools, but you'd need to Google for them, as I don't know where to suggest
    > for this particular functionality.
    >
    > Larry Linson
    > Microsoft Access MVP
    >
    >
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page