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
LVL 81
zorvek (Kevin Jones)ConsultantAsked:
Who is Participating?
 
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
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.