Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Access (https://www.askmehelpdesk.com/forumdisplay.php?f=441)
-   -   Duplicating a File. (https://www.askmehelpdesk.com/showthread.php?t=352900)

  • May 12, 2009, 10:58 AM
    mcleyn
    Duplicating a File.
    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?
  • May 12, 2009, 04:45 PM
    ScottGem

    Just copy the file as you would any file. Then open the copy and delete all the records in each table.
  • May 13, 2009, 05:40 AM
    mcleyn
    Quote:
    Originally Posted by ScottGem View Post
    Just copy the file as you would any file. Then open the copy and delete all the records in each table.
    Thanks, works!
  • May 13, 2009, 06:13 AM
    mcleyn
    Quote:
    Originally Posted by mcleyn View Post
    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?
  • May 13, 2009, 06:29 AM
    ScottGem
    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.
  • May 13, 2009, 06:37 AM
    mcleyn
    Quote:
    Originally Posted by ScottGem View Post
    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?
  • May 13, 2009, 06:52 AM
    ScottGem

    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.
  • May 13, 2009, 07:04 AM
    mcleyn
    Quote:
    Originally Posted by ScottGem View Post
    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?
  • May 13, 2009, 07:09 AM
    ScottGem

    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.
  • May 13, 2009, 08:47 AM
    mcleyn
    Quote:
    Originally Posted by ScottGem View Post
    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?
  • May 13, 2009, 09:04 AM
    mcleyn
    Quote:
    Originally Posted by mcleyn View Post
    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?
  • May 13, 2009, 01:49 PM
    ScottGem

    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.
  • May 15, 2009, 10:57 AM
    mcleyn
    Quote:
    Originally Posted by ScottGem View Post
    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.

    • All times are GMT -7. The time now is 05:40 AM.