[Last Call] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 401
  • Last Modified:

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

I have Access 2000, 2002, and 2003. Microsoft's add-in (http://support.microsoft.com/kb/q162861) 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 http://www.fabalou.com/Access/Modules/accessreplica.asp but it contains errors and I don't have the time to debug it.

zorvek (Kevin Jones)
zorvek (Kevin Jones)
1 Solution
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?


Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now