reset auto number

D

David_UK

Active Member
Joined
Mar 18, 2003
Messages
299
Does anyone know the SQL command to reset the auto number? I have deleted records and now want the number to start from one again not, say, 154?

I have tried an append query but would like the code :oops:
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
Sort by date Sort by votes
You cannot reset Autonumbers from code.
Depending on the version of Access you can reset it by compacting the database.
See This Article for more details

Autonumbers should really be used as unique identifiers for a record and their actual value does not matter. If you need a number for an Invoice or something it is best to create your own. see This Article for more info.
The problem with using Autonumbers for sequential numbering is that you can easily lose numbers, by cancelling a record, or a system crash after data entry has started.

HTH

Peter
 
Upvote 0
Thanks, been raking my brains trying to figure it out, I am fairly new to SQL so don't know the limitations yet.
 
Upvote 0
You must log in or register to reply here.

Similar threads

C
  • Question
Linked Excel table in Access - field values change as I navigate?
Replies
5
Views
479
welshgasman
welshgasman
CPGDeveloper
  • Question
Creating a Fillable PDF Directly From Access
Replies
5
Views
802
CPGDeveloper
CPGDeveloper
S
  • Question
ACCESS, VBA: Fetch data from sql server and paste it into local table.
Replies
3
Views
2K
Micron
M
K
  • Solved
Append Query with Criteria from Linked Excel Tables
Replies
7
Views
1K
Micron
M
JenniferMurphy
  • Question
How to structure a variable product rating database
Replies
5
Views
819
mdmilner
M

Forum statistics

Threads
1,221,557
Messages
6,160,477
Members
451,650
Latest member
kibria

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top