Is it possible to remove system generated fields as a result of a replicated table in access 2010?

Posted on 2011-04-19
Last Modified: 2012-06-27
I have a 2007 access database that was replicated and the primary tables now have several system generated fields.  I can't figure out how to remove them.  I'm importing data from these tables into a new unreplicated 2010 project, and some of their properties are keeping me from doing it (auto-number fields, for example).  thanks
Question by:mbmartin0409
    LVL 56

    Expert Comment

    by:Jim Dettman (Microsoft MVP/ EE MVE)
    Two tools that I'm aware of:

       Michael Kaplan's TSI Un-Replicator Add-in

       Graham Search's Unreplicate Utility

    There is also this MSKB article, which documents a FAQ covering un-replicating a DB.

    LVL 56

    Expert Comment

    by:Jim Dettman (Microsoft MVP/ EE MVE)
    oops, link for Graham's is no long valid....

    LVL 56

    Accepted Solution


    Just tripped across this Office Developer article as well:

      Can't find a current link for Graham's :(


    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    I annotated my article on ransomware somewhat extensively, but I keep adding new references and wanted to put a link to the reference library.  Despite all the reference tools I have on hand, it was not easy to find a way to do this easily. I finall…
    Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
    In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
    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…

    731 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

    15 Experts available now in Live!

    Get 1:1 Help Now