A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How to Reset the record ID



 
 
Thread Tools Display Modes
  #1  
Old July 3rd, 2009, 09:21 PM posted to microsoft.public.access.tablesdbdesign
MikeSr
external usenet poster
 
Posts: 15
Default 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  
Old July 3rd, 2009, 09:38 PM posted to microsoft.public.access.tablesdbdesign
fredg
external usenet poster
 
Posts: 4,386
Default 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  
Old July 4th, 2009, 12:30 AM posted to microsoft.public.access.tablesdbdesign
tina
external usenet poster
 
Posts: 1,997
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:22 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.