topic Geocoding removes my primary key in Data Management Questions https://community.esri.com/t5/data-management-questions/geocoding-removes-my-primary-key/m-p/283433#M16274 <HTML><HEAD></HEAD><BODY><SPAN>In access, I have an address table: AutoId, Address, city, st, zip.&nbsp; It is related to multiple tables based on the ID field.&nbsp; If I geocode this table, I lose my ID because I get a NEW ObjectID.&nbsp; How do I relate the shape or xy back to access?&nbsp; I thought about using the online geocoding service to geocode each record and get it's xy inserted into my table, however it looks like a 100k record limit for batch.</SPAN><BR /><SPAN>Thanks!</SPAN></BODY></HTML> Wed, 29 Dec 2010 19:44:12 GMT ScottDismukes 2010-12-29T19:44:12Z Geocoding removes my primary key https://community.esri.com/t5/data-management-questions/geocoding-removes-my-primary-key/m-p/283433#M16274 <HTML><HEAD></HEAD><BODY><SPAN>In access, I have an address table: AutoId, Address, city, st, zip.&nbsp; It is related to multiple tables based on the ID field.&nbsp; If I geocode this table, I lose my ID because I get a NEW ObjectID.&nbsp; How do I relate the shape or xy back to access?&nbsp; I thought about using the online geocoding service to geocode each record and get it's xy inserted into my table, however it looks like a 100k record limit for batch.</SPAN><BR /><SPAN>Thanks!</SPAN></BODY></HTML> Wed, 29 Dec 2010 19:44:12 GMT https://community.esri.com/t5/data-management-questions/geocoding-removes-my-primary-key/m-p/283433#M16274 ScottDismukes 2010-12-29T19:44:12Z Re: Geocoding removes my primary key https://community.esri.com/t5/data-management-questions/geocoding-removes-my-primary-key/m-p/283434#M16275 <HTML><HEAD></HEAD><BODY><SPAN>I know I've run across this answer before but can't seem to find any other solution than creating a second key.&nbsp; Seems like extra work to maintain two keys in one table.&nbsp; Anyone have any ideas?</SPAN></BODY></HTML> Tue, 11 Jan 2011 15:01:56 GMT https://community.esri.com/t5/data-management-questions/geocoding-removes-my-primary-key/m-p/283434#M16275 ScottDismukes 2011-01-11T15:01:56Z