[AccessD] autonumber

Drew Wutka DWUTKA at marlow.com
Thu Apr 17 04:45:05 CDT 2003


Aha, but if you develop a system that doesn't delete a record, then the AN
will always be incremented.  (Thus, the resetting is needed during
development, so that it kicks to 1, on the first 'official' record).

Drew

-----Original Message-----
From: Wortz, Charles [mailto:CWortz at tea.state.tx.us]
Sent: Wednesday, April 16, 2003 9:10 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] autonumber


Brenda,

M$ only guarantees that an autonumber will be unique.  It does not
guarantee that it will increment by one each time.  Users, and
especially auditors, will question you as to why there are gaps in the
numbering scheme.  What are you going to say when the auditors ask you
where is the paperwork for the missing numbers?

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: Reische, Brenda L. [mailto:reische at mdh.org] 
Sent: Wednesday 2003 Apr 16 08:12
To: 'accessd at databaseadvisors.com'
Subject: RE: [AccessD] autonumber

Charles,
The archives appear to be down right now.  Care to enlighten me?  I let
the users see the autonumber field.  In my ambulance services database,
that is the unique run id number that we use - it prints on the medical
record and
everything...   Why is this a cardinal sin?  

Thanks,
Brenda Reische
McDonough District Hospital

-----Original Message-----
From: Wortz, Charles [mailto:CWortz at tea.state.tx.us] 
Sent: Wednesday, April 16, 2003 7:46 AM
To: accessd at databaseadvisors.com
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


More information about the AccessD mailing list