I suppose the kind of information you have in the two databases are the same ?
Otherwise it is no use (but no problem too :-)
What kind of primary key do you have in each table : is there such thing as the
primary key of table1 of database1 has the same value as primary key of table1
of database2 ? In this case fusion might become difficult (attempt to duplicate
primary keys, or/and loss of the links between the tables).
Be cautious, make backups first, but you can declare each table of database1 as
an external file of database2, then try to make insert queries (insert the
records of db1.table1 into db2.table1)
Always start with table 1 (because table 2 might depend on it, if there are
referential integrities), then table2, then table 3
Does it help ?
Gilbert
________________________________
De : [email protected] [mailto:[EMAIL PROTECTED] De la part de
alison325
Envoyé : lundi 7 avril 2008 07:17
À : [email protected]
Objet : [ms_access] Merging two Access Databases
Hi everyone
Hoping someone can help me with this, or clarify what is or isn't
possible.
I have two databases (inherited from colleagues)that I would like to
merge into one database.
In each database:
Table 1 has a one-to-many relationship with Table 2
Table 2 also has a one to many relationship with Table 3
The records in Tables 1 and 3 are identical in each database, but
Table 2 has unique records in each database.
Is there a way to merge both databases without losing the
relationships between tables?
I'd be very grateful for any suggestions or advice anyone can offer.
Alison
[Non-text portions of this message have been removed]
