Combine databases

  • Thread starter Thread starter Sharon
  • Start date Start date
S

Sharon

Originally, I set up a database per client, but found out
later that was not the best way because when I want to
change the format, I have to go to each database and try
to make the same changes. I now want to combine all of
my databases into one large database. I thought that I
should do an append query, but I got confused. Can
somebody please give me the steps to combine two
databases. Thanks in advance.
 
Hi Sharon,
If you want to have all your data in 1 mdb, you can use
append queries. Just link or import your other tables
into the mdb then create the append query(s). Make sure
your queries/reports will handle multiple clients.
Another option, if you want to maintain separate mdbs,
is to read up on replication.

HTH
 
Originally, I set up a database per client, but found out
later that was not the best way because when I want to
change the format, I have to go to each database and try
to make the same changes. I now want to combine all of
my databases into one large database. I thought that I
should do an append query, but I got confused. Can
somebody please give me the steps to combine two
databases. Thanks in advance.
Click to expand...

How are you using the term "database" here? Separate .mdb files, each
with multiple forms, queries, reports, tables, etc.? or are you using
the word "database" to refer to Tables?

It's doable, but I'd like to get a clearer idea of the problem!
 
Back
Top