hangglide
Hangglider
- Local time
- Today, 17:29
- Joined
- May 9, 2001
- Messages
- 35
Is it possible to put an Autonumber field into a make table query?
I am using an external application (ArcGIG 8.1) to access an Access database. I have put together a query that returns the table I need for ArcGIS but ArcGIS insists on creating a unique identifier in the table before it will regester the table and let me use it. Now when I enter new data into the database and "Update" the table by running the "Make table" query, the index that ArcGIS created is deleted. This is obviously not good for my ArcGIS application.
I need a way to repopulate ALL the fields in my "Make Table" query table update without deleting the autonumber field (E.G. I cant just append a table because the query will change information in individual records as new information is gained).
Hope someone can help.
Leo
I am using an external application (ArcGIG 8.1) to access an Access database. I have put together a query that returns the table I need for ArcGIS but ArcGIS insists on creating a unique identifier in the table before it will regester the table and let me use it. Now when I enter new data into the database and "Update" the table by running the "Make table" query, the index that ArcGIS created is deleted. This is obviously not good for my ArcGIS application.
I need a way to repopulate ALL the fields in my "Make Table" query table update without deleting the autonumber field (E.G. I cant just append a table because the query will change information in individual records as new information is gained).
Hope someone can help.
Leo
