zorvek (Kevin Jones)
asked on
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
Kevin
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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