[AccessD] autonumber

I'd only worry about that if you plan to create more that 4 billion 
odd entries - which will take about 135 years if you create one new 
record a second on average.



On 16 Apr 2003 at 19:31, John Eget wrote:

> 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
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com


-- 
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System 
Support.