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
|
|||
|
|||
Autonumbers...
I have a table with an autonumber field. I routinely delete records from this table and add new ones using code. Is there a way to reset the autonumber to begin again at "1" each time I do this?
Many thanks for your help! |
#2
|
|||
|
|||
Autonumbers...
Hi, My name is Amy Vargo. Thank you for using the Microsoft Access Newsgroups. I included a link to an article that tells you how to reset an AutoNumber. 812718 How to reset an AutoNumber field value in Access http://support.microsoft.com/?id=812718 I hope this helps! If you have additional questions on this topic, please respond back to this posting. Regards, Amy Vargo Microsoft Access Engineer This posting is provided 'AS IS' with no warranties, and confers no rights. You assume all risk for your use. © 2001 Microsoft Corporation. All rights reserved. |
#3
|
|||
|
|||
Autonumbers...
=?Utf-8?B?Sm9l?= wrote in
: Is there a way to reset the autonumber to begin again at "1" each time I do this? "If you care what value an Autonumber has, then you probably should not be using an Autonumber" Tim F |
#4
|
|||
|
|||
Autonumbers...
Joe,
This will do it: compact the database after the delete. -- Steve Schapel, Microsoft Access MVP Joe wrote: I have a table with an autonumber field. I routinely delete records from this table and add new ones using code. Is there a way to reset the autonumber to begin again at "1" each time I do this? Many thanks for your help! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Restart Autonumber | Traci | New Users | 22 | July 21st, 2004 01:10 AM |
Autonumbers | David | Database Design | 2 | June 7th, 2004 01:39 PM |
Remove Negative AutoNumbers | Matt | Database Design | 2 | May 24th, 2004 04:34 PM |