Compare and update one mdb from another

  • Thread starter Thread starter Kjell Harnesk
  • Start date Start date
K

Kjell Harnesk

There is a free tool somwhere out there that compares the tables in two
mdb's and generates code to update the "destination" mdb with the
differences in the "source" mdb. I can´t find it. Anyone of You can help?
 
Kjell said:
There is a free tool somwhere out there that compares the tables in
two mdb's and generates code to update the "destination" mdb with the
differences in the "source" mdb. I can´t find it. Anyone of You can
help?

Why not just copy all the data from the source database replacing the
existing data?
 
Why not just copy all the data from the source database replacing the
existing data?

The data is not the problem it is the structure. Several fields has been
added to a number of tables.
 
Kjell said:
The data is not the problem it is the structure. Several fields has
been added to a number of tables.

If possible, you might consider just linking to the other tables and not
maintaining them at the "destination" database.

You also might consider just copying the tables complete with data to
the destination table after deleting the existing table.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top