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

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.

LVL 81
zorvek (Kevin Jones)ConsultantAsked:
Who is Participating?
zorvek (Kevin Jones)ConsultantAuthor Commented:

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?

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.