[AccessD] Resetting an AutoNumber

Arthur,

The process you describe will work.  I don't know if it's a recommended
strategy but deleting and recreating the ANPK field works too.  I like your
way better just because the compact process cleans up the file.

HTH,

Rusty

-----Original Message-----
From: Arthur Fuller [mailto:fuller.artful at gmail.com]
Sent: Sunday, June 24, 2007 8:19 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Resetting an AutoNumber


Hi all,

It's been a while since I worked in an MDB, and in the immortal words of The
Simpsons, there are no stupid questions, only stupid people -- so I'm
stupid. I can't remember. Is it enough to nuke all the rows in a table, and
then compact+repair? Will that reset the ANPK to 1?

Struggling through this senior moment,
Arthur
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

**********************************************************************
WARNING: All e-mail sent to and from this address will be received,
scanned or otherwise recorded by the CPI Qualified Plan Consultants, Inc.
corporate e-mail system and is subject to archival, monitoring or review 
by, and/or disclosure to, someone other than the recipient.
**********************************************************************