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
|