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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber without a autonumber field 3
Primary Key Value 3
Autonumber is reusing previously assigned numbers-creating duplica 3
AutoNumber correlate with Number? 2
Autonumber records inserted in gaps 1
primary key - concatenated or autonumber? 6
2007 Being Weird with AutoNumber 3
Changing MainID Autonumber into auto added number YY0000, incl. ye 1

Back
Top