Combine 2 data bases

[Guest]

I have designed 2 seperate data bases relating to Finances that have 2 Bank
Accounts/Statements. They are both very similar. Is there a way I can link
the 2 for the purpose of designing reports etc.

Thanks for any help

 

[Rob Parker]

You can design (yet another) database , which uses links to the tables in
your two existing databases, and build the reports in that database. To do
so, use the File | Get External Data | Link Tables ... menu item in the new
database.

But why would you want to? Why not simply merge your two existing databases
into one, rather than producing a third one? That's certainly the way I'd
go. You seem to want to make life much too complicated ;-)

HTH,

Rob

 

[Guest]

Thanks for the information Rob. The two data bases have pretty well
identical tables and relationships as they relate to 2 different Bank
accounts.
How would I go about merging the two into just the one? as the Financial
Data needs to be seperate for Bank Reconciliations and reporting and then
combined for Taxation purposes.

Thanks again

 

[Rob Parker]

Hi Roger,

Without details of your tables/relationships, it's difficult to be exact.
However, I expect that all you'd probably need is an additional field in one
(or maybe more) table(s) to hold the AccountNumber, which you can then use
in your queries to separate the records as desired. You can fill this field
for each database using an Update query; and then merge the tables via a
series of Append queries.

If you've got autonumber fields used as primary keys, which are used as
foreign keys in relationships, it becomes somewhat more complicated, as the
primary key will change when you do the append, but the foreign keys will
not. You will need to copy the existing autonumber field to a new field
before doing the append, and later use this field to link with the related
tables in update queries to change the foreign keys to the correct new
values.

HTH,

Rob

 

[Rob Parker]

And one more thing ...

Make backup copies of each database before you start ;-)

Rob

 

[i_takeuti]

Thanks for the information Rob. The two data bases have pretty well
identical tables and relationships as they relate to 2 different Bank
accounts.
How would I go about merging the two into just the one? as the Financial
Data needs to be seperate for Bank Reconciliations and reporting and then
combined for Taxation purposes.

Thanks again