Copying, transferring data from 1 DB to another

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
I am using MS-Access 97/2003 (SP1) with Windows XP.
I have created a database, we'll call DB-A. I have made a copy of DB-A,
we'll call DB-B. Data is still being stored in DB-A while I make
enchancements to DB-B. My question is: How do I copy the NEW data in DB-A
into DB-B???

Thank you,
 
You have a basic design flaw. Your code, queries, forms, macros, and reports
should not be in the same mdb file with the data. You need to split your
database. Then, you will have only tables in the Back End database. So now
you will have DB-A and DB-A_BE. Create a copy of DB-A_BE to DB-B_BE, then
use the linked table manager in DB-B to link to the data in DB-B_BE so you
don't corrupt production data with your testing.
So, when you are done making changes to DB-B, delete DB-A, copy DB-B to DB-A
and relink to the tables in DB-A_BE.

That's the way it is done.
 
Hello,
I did not create the original database. So, are you saying I should follow
the procedure you stated, then copy the data over???
 
No, he's saying to follow the procedure he stated, and you won't have to
copy the data: it'll be in DB-A_BE.
 
Back
Top