We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Is it possible to remove system generated fields as a result of a replicated table in access 2010?

Medium Priority
532 Views
Last Modified: 2012-06-27
I have a 2007 access database that was replicated and the primary tables now have several system generated fields.  I can't figure out how to remove them.  I'm importing data from these tables into a new unreplicated 2010 project, and some of their properties are keeping me from doing it (auto-number fields, for example).  thanks
Comment
Watch Question

Jim Dettman (EE MVE)President / Owner
CERTIFIED EXPERT
Fellow
Most Valuable Expert 2017

Commented:
Two tools that I'm aware of:

   Michael Kaplan's TSI Un-Replicator Add-in

   http://www.trigeminal.com/lang/1033/utility.asp?ItemID=7#7

   Graham Search's Unreplicate Utility

   http://www.pacificdb.com.au/MVP/Code/UnReplicate.htm

There is also this MSKB article, which documents a FAQ covering un-replicating a DB.

 http://support.microsoft.com/kb/282977/en-us

JimD.
Jim Dettman (EE MVE)President / Owner
CERTIFIED EXPERT
Fellow
Most Valuable Expert 2017

Commented:
oops, link for Graham's is no long valid....

JimD.
President / Owner
CERTIFIED EXPERT
Fellow
Most Valuable Expert 2017
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.