If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to combine multiple Access databases
I have 3 Access Databases that I need to combine into one (The primary
database is one of the 3) and if possible have any information added to the subordinate databases automatically be entered into the primary database. Does anyone know how to do this? -- Thanks, Kelly |
#2
|
|||
|
|||
I would probably import the data tables from the "bad" databases and then
create update queries to copy the records to the desired tables in the "good" database. Once I had everything there and working, I'd delete the "bad" databases. Rick B "Kelly Hawthorne" wrote in message ... I have 3 Access Databases that I need to combine into one (The primary database is one of the 3) and if possible have any information added to the subordinate databases automatically be entered into the primary database. Does anyone know how to do this? -- Thanks, Kelly |
#3
|
|||
|
|||
On Wed, 2 Mar 2005 09:55:09 -0800, Kelly Hawthorne
wrote: I have 3 Access Databases that I need to combine into one (The primary database is one of the 3) and if possible have any information added to the subordinate databases automatically be entered into the primary database. Does anyone know how to do this? This can be easy (using File... Get External Data... Link and running a series of append queries) or almost nightmarishly difficult (if you have duplicate autonumber values, almost-duplicate data which must be manually investigated to see if it's actually a duplicate or just a similar new record, etc.) Storing the "same" data in two or three databases is *emphatically* bad design if there is ANY way to avoid it. Why three databases? Are these on the same LAN, or at remote locations? Is there any possibility of using a split database where the tables are in a .mdb file on a shared drive, with the three users all linking to it? John W. Vinson[MVP] |
#4
|
|||
|
|||
I found that I was able to cut and paste from within Access.
Thank you for the ideas. I printed them and will hang on to them for future use. Kelly "John Vinson" wrote: On Wed, 2 Mar 2005 09:55:09 -0800, Kelly Hawthorne wrote: I have 3 Access Databases that I need to combine into one (The primary database is one of the 3) and if possible have any information added to the subordinate databases automatically be entered into the primary database. Does anyone know how to do this? This can be easy (using File... Get External Data... Link and running a series of append queries) or almost nightmarishly difficult (if you have duplicate autonumber values, almost-duplicate data which must be manually investigated to see if it's actually a duplicate or just a similar new record, etc.) Storing the "same" data in two or three databases is *emphatically* bad design if there is ANY way to avoid it. Why three databases? Are these on the same LAN, or at remote locations? Is there any possibility of using a split database where the tables are in a .mdb file on a shared drive, with the three users all linking to it? John W. Vinson[MVP] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
What is the difference between 2002 and 2003? | Red Sonya | General Discussion | 2 | March 1st, 2005 05:10 AM |
Book recommendations, please | Top Spin | New Users | 2 | March 1st, 2005 12:43 AM |
Encrypt AccesS File? | milest | General Discussion | 2 | February 9th, 2005 07:58 PM |
Is it possible to link to tables in multiple databases?? | tlyczko | Database Design | 2 | February 2nd, 2005 07:38 PM |
Configuring Access for multiple user access across a workgroup net | vanGogh | General Discussion | 3 | January 26th, 2005 10:54 PM |