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

x
  • 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.

Kevin
0
zorvek (Kevin Jones)
Asked:
zorvek (Kevin Jones)
1 Solution
 
peter57rCommented:
0
 
zorvek (Kevin Jones)ConsultantAuthor Commented:
Pete,

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?

Kevin
0

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