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
|
|||
|
|||
How to Reset the record ID
Experimenting and learning Access 2007. I have several tables. I manually
deleted the records in each table, so that I can start with new data. The ID Value seems to pick up where it left off. How do I reset this back to 0? Mike |
#2
|
|||
|
|||
How to Reset the record ID
On Fri, 3 Jul 2009 13:21:01 -0700, MikeSr wrote:
Experimenting and learning Access 2007. I have several tables. I manually deleted the records in each table, so that I can start with new data. The ID Value seems to pick up where it left off. How do I reset this back to 0? Mike After you delete all of the records in the table, compact the database. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
#3
|
|||
|
|||
How to Reset the record ID
you can compact the database after deleting the records, to "reset" the
Autonumber field. but it shouldn't matter what the Autonumber values are. the Autonumber's purpose is to uniquely identify each record in a table *to the system*. it's not intended to have any other use or value in a table, and shouldn't be seen by users. if you need to assign consecutive number to records in your table for human consumption (invoice numbers, purchase order numbers, check numbers, etc) then best practice is to add a separate field to the table and assign the numbers to that field either manually or programmatically during data entry in a form. hth "MikeSr" wrote in message ... Experimenting and learning Access 2007. I have several tables. I manually deleted the records in each table, so that I can start with new data. The ID Value seems to pick up where it left off. How do I reset this back to 0? Mike |
Thread Tools | |
Display Modes | |
|
|