|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 5th, 2004, 10:43 AM
|
|||
|
|||
Auto Number Field Question...
Hi I have an Auto Numbger Field...
I have some test records in the database to test... How can I delete the test records and make the Auto Numebr Field go back to 1?? Many Thanks James 
|
|
#2
May 5th, 2004, 11:46 AM
|
|||
|
|||
|
Auto Number Field Question...
James
A scan through this newsgroup (tablesdbdesign) will reveal a recurring theme asking why you would care what value the Autonumber has. The Access Autonumber is designed to provide a unique row identifier, and only rarely needs to (or should) be displayed to users. So, what are your business needs to have it reset to "1"? -- Good luck Jeff Boyce Access MVP
|
|
#3
May 5th, 2004, 11:58 AM
|
|||
|
|||
|
Auto Number Field Question...
James,
If you delete all the reords and compact the database, the numbering will start over from 1 the next time you enter dat. HTH, Nikos "James" wrote in message ... Hi I have an Auto Numbger Field... I have some test records in the database to test... How can I delete the test records and make the Auto Numebr Field go back to 1?? Many Thanks James
|
|
#4
May 6th, 2004, 01:58 AM
|
|||
|
|||
|
Auto Number Field Question...
Also, simply create your own procedure that simulates the autonum counter
facility. Rich
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
