'Unreplicating' an Access 2002 database

Posted on 2006-03-28
Last Modified: 2008-02-01
Does anyone know of a way to 'unreplicate' an Access 2002 database?
Question by:sprosser
    LVL 77

    Accepted Solution

    Hi sprosser,
    Very messy business.
    See item 40 in the FAQ:

    LVL 48

    Expert Comment

    by:Gustav Brock
    Maybe this tool can help you:

    It's for A2000 but it might work for A2002 as well.


    Author Comment

    I had to append all of the data into a new 'master' structure on my end.  All tables and indexes, keys, etc. existed in blank tables before I started and I had to append each table one at a time.  It didn't matter what I tried as far as importing into a new db, using the recommended tool, etc.  None of those methods would remove the reference fields to the replicated table.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Suggested Solutions

    Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
    Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
    In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
    With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now