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 Harnesk

Kjell Harnesk wrote:
> 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?

--
Joseph Meehan

Dia duit

On Sat, 28 Jan 2006 12:46:24 GMT, Joseph Meehan wrote:

> Kjell Harnesk wrote:
>> 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?

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

Kjell Harnesk wrote:
> On Sat, 28 Jan 2006 12:46:24 GMT, Joseph Meehan wrote:
>
>> Kjell Harnesk wrote:
>>> 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?
>
> 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.

--
Joseph Meehan

Dia duit