Update an index/identity column

  • Thread starter Thread starter Chris F
  • Start date Start date
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...
 
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.
 
Back
Top