View Single Post
  #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