reusing an AutoNumber Primary key

S

SLP

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
 
R

Rick B

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
 
D

david epsom dot com dot au

You can set the field to anything when you append records to the table.
 

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 field in Excel that behaves the same as Access 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
How to change font & size of (all) citation numbers? 7
VBA word change keys 0
Autonumber records inserted in gaps 0
Autonumber without a autonumber field 3
primary key - concatenated or autonumber? 6
Autonumber is reusing previously assigned numbers-creating duplica 4

Top