How do I Combine two databases???

[bjdobs]

I have built two separate databases that I now want to pull them together ... I started with 3rd new blank database and used the import wizard to import all the tables, Queries, Forms, and Modules from the 1st Database ... then imported all the Queries, Forms, and Modules from the second database. The tables from the second database are multiuser update tables so I split the second database and then linked the tables into my new Database.

Go to try and run the main Form/procedures and crash ... I do a compact and repair and still crash (can't find modules)

The Form Code and some modules appear to be missing or have broken links even though the module names are in the object list. If I do an import from one database the "copy" procedures work until I pull in the second database

Am I doing something wrong?

Instead of making a 3rd database I took the second database and made a copy of it then attempted to import the 1st database into it ... again the same issue ... its almost as though the import process is not working as I expect or there is a conflict between the two databases and no errors were given during the import.

 

[bjdobs]

I believe I solved the problem ... Modules appear to have been in conflict ... DB 1 had 2 modules; a Global and a Tools where DB 2 only had a Module1 ... I suspect Global and Module1 couldn't coexist ... I solved the problem by importing the modules from the DB 1 then cut an pasting the code from Module1 into Global.