How do I reset the autonumber to 1?

G

Guest

Hi,

I actually copied over the database of previous yr to tis yr. So as i want
to enter the data, the autonumber continues from the previous database. So
how do i reset the autonumber back to 1?
 
N

Nikos Yannacopoulos

Cheyanne,

After deleting all the records in the table, do a compaction (Tools >
Database Utilities > Compact and Repair Database) - which you should do
anyway! - and the autonumber will reset.
That said, why should you care? An autonumber is just for Access's own
internal use, it's not supposed to mean anything to the user anyway -
actually, the user shouldn't even see it. If your field does mean
something to the user, or you need, say, consecutive numbering, then you
should not be using an autonumber to begin with.

HTH,
Nikos
 

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

Append query - Append to table with Autonumber field 2
Autonumber problem 6
query that brings a autonumber field 6
reset autonumber to '0' following delete query prior to appending 1
Resetting auto-number back to 1? 4
Another MTD/YTD Running Totals Question 2
Reset autonumber 2
Access Sequentially numbered column that resets with each new sample 0

Top