Remove database replication fields from a database or "de-replicate" a database.

Posted on 2006-04-30
Last Modified: 2008-01-09
I have Access 2000, 2002, and 2003. Microsoft's add-in ( only works with earlier versions of Access. I need to de-replicate an Access 2000 database. How can I do this without re-creating the entire database manually? Anyone have any VBA code that will do this? I tried the routine located at but it contains errors and I don't have the time to debug it.

Question by:zorvek (Kevin Jones)
    LVL 77

    Accepted Solution

    LVL 81

    Author Comment

    by:zorvek (Kevin Jones)

    That's a sweet little ditty! Thanks! The documentation states that all that is done is removing fields with the dbSystemField attribute on them. Would this be possible with VBA?


    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Join & Write a Comment

    This isn't a frequent question on EE. I must have seen it three or four times (among several thousand questions). However, I use this trick quite often, most frequently as a delayed Current event. A form does not expose it's calculation dependenc…
    A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

    729 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

    20 Experts available now in Live!

    Get 1:1 Help Now