Write down the name of the autonumber field then delete the field in the Design View. Create a new field with the same name. Declare the data type as autonumber.
queries > create query in design view> show table> add> close
select sort
in query menu > make table query>table name>>ok
query>run
a dailog will appear
now file>close>no>make table
design>autonumber
That's very easy. Just modify the table structure and turn the field to a simple integer field with no increment. Try this:
ALTER TABLE ALTER COLUMN INT
In order to reset this type of features you will need to do one particular thing. I would first delete the whole Access file then chose to reinstall the whole file.
