I am having a problem trying to set the autonumber in a table back to 0. I worked through the help info and was able to do this on my laptop(Win 98). I did this by creating a temporary table with one record with one long integer field with a default value of 0. I would append this record to another table(after deleting all previous records). I would then append attitional records from another table which would then be numbered 1 through whatever. I cannot seem to do this under XP at work, as it keeps incrementing. Do anyone have any ideas? Thanks in advance for any help.
Changing autonumbers
- Thread starter dwhite
- Start date
