merging two databases

[Karen]

I have an application that I've been working on for several years.

The problem is that at one time I started to add a new function to the
application and got pulled off of that project to make some revisions
to the existing application. Now I have two copies of the
application; one with the forms/table changes etc that I started when
I wanted to add the new function, and the active application with
these revisions.

Can I somehow merge the two together so I have a database with the new
function and the revisions?

thanks for any input.

Karen

 

[Damon Heron]

Create a new db and import the tables, forms, queries, reports and modules
from each existing db that you need. Then compile and run.

Damon

 

[John W. Vinson]

I have an application that I've been working on for several years.

The problem is that at one time I started to add a new function to the
application and got pulled off of that project to make some revisions
to the existing application. Now I have two copies of the
application; one with the forms/table changes etc that I started when
I wanted to add the new function, and the active application with
these revisions.

Can I somehow merge the two together so I have a database with the new
function and the revisions?

thanks for any input.

Karen

This can be very easy - back up both databases, use File... Get External
Data... Import to import the new stuff, compile and test; or it can be an
absolute nightmare, if there is data content in both databases with
relationships to other tables, duplicate autonumber primary keys for different
data, etc. In short - It All Depends.

I would certainly work on a private copy and make sure that everything is
working cleanly first.

If this is a multiuser app, it should certainly be split into a frontend (with
forms, reports, queries and code) and backend (shared, with the tables); if
it's not, this might be a good opportunity to do so.