How set starting number for autonumber field ?

R

Ryan

How do I set the starting autonumber to other than 1 ??

Does it matter if the table has already had records added so long as they have been deleted
i.e. if the table is empty is it possible even though it had had records added then deleted

I looked in Help but its very vague.
 
J

Jeff Boyce

Ryan

If you (or your users) care about the value of an autonumber field, you
probably need to make a change. Access Autonumbers are intended as
generally unique row identifiers, and usually are not fit for human
consumption.

Perhaps you could describe a bit further WHY you want to do this?

More info, please...

Jeff Boyce
<Access MVP>
 

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
Autonumber 5
getting an autonumber field to go beyond 3999 5
Autonumber records inserted in gaps 0
values in the AutoNumber field are not sequential, why? 5
Autonumber numbers 2
How do I set focus (and select text) on a text box on a modeless userform? 0
Autonumber Field 2

Top