Welcome to SPN

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

Sign Up Now!

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
    >
    >
     

Share This Page