[AccessD] autonumber

growth of the number over a period of time

----- Original Message ----- 
From: "Wortz, Charles" <CWortz at tea.state.tx.us>
To: <accessd at databaseadvisors.com>
Sent: Wednesday, April 16, 2003 8:46 AM
Subject: RE: [AccessD] autonumber


> John,
> 
> I cannot let this pass without asking why do you care?  You are not
> committing the cardinal sin of allowing you users to see the autonumber
> field are you?  <grin>  If so, check the archives on why this is a
> cardinal sin.
> 
> Charles Wortz
> Software Development Division
> Texas Education Agency
> 1701 N. Congress Ave
> Austin, TX 78701-1494
> 512-463-9493
> CWortz at tea.state.tx.us
> 
> 
> 
> -----Original Message-----
> From: Drew Wutka [mailto:DWUTKA at marlow.com] 
> Sent: Wednesday 2003 Apr 16 05:02
> To: 'AccessD at databaseadvisors.com '
> Subject: RE: [AccessD] autonumber
> 
> A make table query should already 'reset' the AutoNumber, since it is
> going to make a new table. An append query can be used to 'set' numbers
> within an AutoNumber field, however, it doesn't reset the counter, it
> can just 'ignore' it.  If you delete the data in a table, to resent the
> AutoNumber counter, compact the database.  It will reset the counter (on
> an incremental
> AN) to the highest number plus 1 (or 1, if there are no records
> remaining).
> 
> Drew
> 
> -----Original Message-----
> From: John Eget
> To: AccessD at databaseadvisors.com
> Sent: 4/16/03 4:43 AM
> Subject: [AccessD] autonumber
> 
> Is there a way to reset the autonumber to 1 of a make table query or an
> append or a table I just finished deleting the information from? John
> <<ATT46269.txt>> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com