Geocoding removes my primary key

589
1
12-29-2010 11:44 AM
ScottDismukes
New Contributor
In access, I have an address table: AutoId, Address, city, st, zip.  It is related to multiple tables based on the ID field.  If I geocode this table, I lose my ID because I get a NEW ObjectID.  How do I relate the shape or xy back to access?  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.
Thanks!
Tags (2)
0 Kudos
1 Reply
ScottDismukes
New Contributor
I know I've run across this answer before but can't seem to find any other solution than creating a second key.  Seems like extra work to maintain two keys in one table.  Anyone have any ideas?
0 Kudos