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
|
|||
|
|||
Restart Autonumber
Is it possible to re-start an autonumber field with "1" after all the data
has been deleted? |
#2
|
|||
|
|||
Yes. Compact the database after you've deleted all the records from the
table. -- Ken Snell MS ACCESS MVP "DSmith" wrote in message ... Is it possible to re-start an autonumber field with "1" after all the data has been deleted? |
#3
|
|||
|
|||
Thanks, worked great, I can't believe it was that easy!
"Ken Snell [MVP]" wrote in message ... Yes. Compact the database after you've deleted all the records from the table. -- Ken Snell MS ACCESS MVP "DSmith" wrote in message ... Is it possible to re-start an autonumber field with "1" after all the data has been deleted? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
insert and autonumber | TheSniipe | Running & Setting Up Queries | 1 | December 6th, 2004 11:39 PM |
Problem with AutoNumber | accessmonk | Database Design | 2 | September 30th, 2004 08:57 PM |
keeping track of "Escaped" Autonumber records | Paul James | Using Forms | 7 | September 28th, 2004 12:06 AM |
Autonumber | Ally H. | General Discussion | 7 | August 27th, 2004 04:51 PM |
autonumber | Deepak | General Discussion | 3 | June 18th, 2004 09:07 PM |