Results 1 to 2 of 2
  1. #1
    Spattrell is offline Novice
    Windows 8 Access 2013 64bit
    Join Date
    Jul 2019

    Creating Copy of DB Without Them Linking


    I'm currently working on a project for work but haven't used Access in a few years. I'm trying to create a copy of the production db to use as a test db. The issue I am having is whether I simply copy the database, save as a new name and location, or import the db into a blank db the db's remain linked. By this I mean if I make any updates in the test db they will show up in the production db and vice versa. I was wondering if anyone else had experienced this and if so how do I go about disconnecting them?

    Any help is greatly appreciated.
    Thank you for your time.

  2. #2
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Ontario, Canada
    sounds like they are split, so
    - create copy of front and back ends in another location that is a Trusted Location
    - open the new fe and go to linked table manager
    - relink all currently linked tables between the new fe and new be
    - carefully examine all linked table paths by checking that property in the nav pane
    As an additional precaution, perhaps
    - make small inconspicuous edit(s) and close new db go to production version and ensure that change is not there

    If during linking you are prompted for the location every time, use notepad to create the entire path string and copy/paste from there.
    - "doesn't work" doesn't help. Implement changes in copies of your database.
    "Everyone has a photographic memory; some just don't have film." Steven Wright

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Database creating a copy of itself on a shared drive
    By Harvard Graphics in forum Access
    Replies: 6
    Last Post: 05-23-2018, 03:29 PM
  2. Linking Tables - Can I copy common data?
    By PATRICKPBME in forum Access
    Replies: 2
    Last Post: 04-28-2017, 02:38 PM
  3. Creating a copy of records between databases
    By andrewosborne in forum Import/Export Data
    Replies: 4
    Last Post: 09-22-2011, 12:56 AM
  4. Creating a form while linking two tables
    By sai_rlaf in forum Forms
    Replies: 1
    Last Post: 04-29-2011, 02:08 PM
  5. Replies: 0
    Last Post: 10-15-2009, 02:08 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums - Senior Forums