PDA

View Full Version : Duplicating a File.


mcleyn
May 12, 2009, 10:58 AM
I currently have a database with MS Access 2000.
I want to make a new database that has the same fields and forms etc. as my current database the only thing different would be the data.
So basically I want two copies of my original database.
I want to have a saved copy of my original database but I also need another copy I need to erase the data in order to begin populating my new database.

My question:
Is it possible to make a duplicate file of my original database; so I can have one to keep on hold as a saved copy and one to erase the data to start populating for my new database?

ScottGem
May 12, 2009, 04:45 PM
Just copy the file as you would any file. Then open the copy and delete all the records in each table.

mcleyn
May 13, 2009, 05:40 AM
Just copy the file as you would any file. Then open the copy and delete all the records in each table.

Thanks, works!

mcleyn
May 13, 2009, 06:13 AM
Thanks, works!

Acutally it didn't work.
I copied the file and then opened it and started to delete my records. When I opened the original file the same records were deleted.
Is it possible to copy the file and not have that happen?

ScottGem
May 13, 2009, 06:29 AM
Is your database split between front and back ends? That would explain deleting the records because you didn't make a copy of the back end as well. Make sure the tables are not linked. If they are you need to copy the source of the links and then relink the front end to the new back end.

mcleyn
May 13, 2009, 06:37 AM
Is your database split between front and back ends? That would explain deleting the records because you didn't make a copy of the back end as well. Make sure the tables are not linked. If they are you need to copy the source of the links and then relink the front end to the new back end.

Do you mean make sure there are no relationships between the tables? How do I make a copy of the back ends?

ScottGem
May 13, 2009, 06:52 AM
No, not relationships. Access has the ability to link to a table that is NOT in the current file. In fact, any application that is used by multiple people should be split up so that the tables are in a back end file and everything else (forms, reports, queries, etc.) are in the front end.

Linked tables are indicated by a different icon then tables in the current file. You can find out what the names of the back ends are by looking in Linked Table Manager.

But the only reason that deleting data while in one MDB would affect the data in a different MDB is if both MDBs were linked to the tables in a third MDB.

mcleyn
May 13, 2009, 07:04 AM
No, not relationships. Access has the ability to link to a table that is NOT in the current file. In fact, any application that is used by multiple people should be split up so that the tables are in a back end file and everything else (forms, reports, queries, etc.) are in the front end.

Linked tables are indicated by a different icon then tables in the current file. You can find out what the names of the back ends are by looking in Linked Table Manager.

But the only reason that deleting data while in one MDB would affect the data in a different MDB is if both MDBs were linked to the tables in a third MDB.

OK yes now I understand the links. I found out the names of the back ends by looking in the Linked Table Manager. So no that I have done this; to make a new copy should I break the links? How do I get around this, is it possible to copy a database like this?

ScottGem
May 13, 2009, 07:09 AM
You have two choices here, depending on what your reasons are for making the copy.

First, you can copy BOTH the front end and backend. Then from Linked Table Manager you can change what backend file is being used.

Second, you can make just a copy of the front end and use File>External Data to import the tables into the front end copy. You will need to delete all the linked tables first.

mcleyn
May 13, 2009, 08:47 AM
You have two choices here, depending on what your reasons are for making the copy.

First, you can copy BOTH the front end and backend. Then from Linked Table Manager you can change what backend file is being used.

Second, you can make just a copy of the front end and use File>External Data to import the tables into the front end copy. You will need to delete all the linked tables first.

Ok I copied the front end and then imported the tables but they still are linked. Can you explain how to unlink the tables?

mcleyn
May 13, 2009, 09:04 AM
Ok I copied the front end and then imported the tables but they still are linked. Can you explain how to unlink the tables?

Actually I was thinking. I just want to put new records in for my tables and front end stuff as well. I mine as well just copy over the front end stuff like forms, queries and reports and then just make new tables of my own instead of having to deal with the unlinking the tables. If I started deleting things in lets say a form of the copied file would it affect the original form? From my understanding front end stuff like forms etc are not linked?

ScottGem
May 13, 2009, 01:49 PM
First, I did tell you that you need to delete the linked tables and replace them with the imported tables.

Second, Forms are generally bound to a table, but if you delete the existing linked table and replace it with an imported table of the same name, that should not present a problem.

But, by far the easiest, is to just make a copy of the back end, and relink the tables using Linked Table manager. Its real easy, Just click to select ALL and check the Always prompt box. You will then be prompted to select the new back end and all the links will be updated.

mcleyn
May 15, 2009, 10:57 AM
First, I did tell you that you need to delete the linked tables and replace them with the imported tables.

Second, Forms are generally bound to a table, but if you delete the existing linked table and replace it with an imported table of the same name, that should not present a problem.

But, by far the easiest, is to just make a copy of the back end, and relink the tables using Linked Table manager. its real easy, Just click to select ALL and check the Always prompt box. You will then be prompted to select the new back end and all the links will be updated.

Ok thank you very much, your help is very appreciated.