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
|
|||
|
|||
Reset autonumber to zero
Hello,
Is there a method to reset the autonumber back to zero in the tables that contain the autonumber field.I have populated the tables with entries to test it out and now i would like to reset the autonumber.Is this possible? Thanks for the support! |
#2
|
|||
|
|||
Reset autonumber to zero
Delete all records from the table, then do a compact and repair.
-- Ken Snell MS ACCESS MVP "joseph" wrote in message ... Hello, Is there a method to reset the autonumber back to zero in the tables that contain the autonumber field.I have populated the tables with entries to test it out and now i would like to reset the autonumber.Is this possible? Thanks for the support! |
Thread Tools | |
Display Modes | |
|
|