[AccessD] Resetting an AutoNumber

In my case, it's short (and long, and just right) for Rusty.  

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


Thanks, Rusty!

(Completely off topic, but what is Rusty short for? Christopher? I have no
idea, not that it matters, just curious.)

Arthur


On 6/24/07, rusty.hammond at cpiqpc.com <rusty.hammond at cpiqpc.com> wrote:
>
> 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
>
-- 
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.
**********************************************************************