Update an index/identity column

C

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...
 
J

John Mishefske

Chris said:
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...
Click to expand...

Compact the database to reset an Autonumber field.
 
Top