reusing an AutoNumber Primary key

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

help please. I have a database and I wanted to know if you delete a record
like number 1 is there a way that I can re-use that number?

Thanks
Lynn
 
Why? An autonumber is simply a key. It should not be something that you
look at or use. If you want a useful number, you should create it manually
or through code as you add records.

Rick B
 
You can set the field to anything when you append records to the table.
 
Back
Top