Results 1 to 2 of 2

Thread: 'merge' two tables

  1. #1

    Thread Starter
    Junior Member
    Join Date
    Nov 1999
    Posts
    17

    Post

    Having two tables in two different database in Access. These two tables have almost 85% the same. Say:
    Table A has attributes: u, v, x, y, z
    Table B has attributes: v, y, z
    A belongs to AA.mdb and B belongs to BB.mdb
    is there a way that we can do the following:
    1. if records deleted in B, do the same thing in A. or vice versa (vv)
    2. if records updated in B, same in A or vv
    3. if inserted in B, insert in A as well. vv

    (compare each record in A with B will waste to much time and is not practical if we have 100 records on each table)

    any help!

    thanks

  2. #2
    Lively Member
    Join Date
    Jan 2000
    Location
    Omaha, Ne
    Posts
    65

    Post

    Are you merging two tables or are you trying to keep two tables the exact same or are you trying to do maintenance with one table if the record happens to exist in the other. Are the tables keyed the same? I would say 100 records will be a sinch to do in code. You might also look into replication.

Posting Permissions

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



Click Here to Expand Forum to Full Width