<div>
Two tools that I'm aware of:<br />
<br />
&nbsp; &nbsp;Michael Kaplan's TSI Un-Replicator Add-in <br />
<br />
&nbsp; &nbsp;<a href="http://www.trigeminal.com/lang/1033/utility.asp?ItemID=7#7" rel="ugc">http://www.trigeminal.com/lang/1033/utility.asp?ItemID=7#7</a> <br />
<br />
&nbsp; &nbsp;Graham Search's Unreplicate Utility <br />
<br />
&nbsp; &nbsp;<a href="http://www.pacificdb.com.au/MVP/Code/UnReplicate.htm" rel="ugc">http://www.pacificdb.com.au/MVP/Code/UnReplicate.htm</a> <br />
<br />
There is also this MSKB article, which documents a FAQ covering un-replicating a DB.<br />
<br />
&nbsp;<a href="http://support.microsoft.com/kb/282977/en-us" rel="ugc nofollow">http://support.microsoft.com/kb/282977/en-us</a><br />
<br />
JimD.
</div>


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 [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 [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 [http://support.microsoft.com/kb/282977/en-us]

JimD.

<div>
oops, link for Graham's is no long valid....<br />
<br />
JimD.
</div>


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

JimD.

<div>
<div class="content wysiwyg-content">
I have a 2007 access database that was replicated and the primary tables now have several system generated fields. &nbsp;I can't figure out how to remove them. &nbsp;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). &nbsp;thanks
</div>
</div>


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

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

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.