Update an index/identity column

[Chris F]

How can I issue a query to update an indexed column in my
table? I've cleared the table with a delete statement,
but now want to reset the index/identity back to 1. Any
idea how to do this using Access? In SQL I would just set
Identity_Insert ON and then run the update, but this
doesn't appear to work with Access...

 

[John Mishefske]

How can I issue a query to update an indexed column in my
table? I've cleared the table with a delete statement,
but now want to reset the index/identity back to 1. Any
idea how to do this using Access? In SQL I would just set
Identity_Insert ON and then run the update, but this
doesn't appear to work with Access...

Compact the database to reset an Autonumber field.

 

[Chris F]

WOW! Much easier than I thought. Thank you very much,
that did the trick!