[AccessD] autonumber

Drew Wutka DWUTKA at marlow.com
Thu Apr 17 04:54:46 CDT 2003


Actually I knew that...somewhere in the back of my mind....but since I do
mostly 97 stuff, I tend to ignore the philanderings of it's offspring!
<grin>

Drew

-----Original Message-----
From: Charlotte Foust [mailto:cfoust at infostatsystems.com]
Sent: Wednesday, April 16, 2003 6:35 PM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] autonumber


FYI, this doesn't work in A2k or AXP with Jet 4 SP 4 or above.  The
counter does not get reset to the next highest number when you compact.
They fixed it in O2k SR-1 and broke it again in the Jet service packs.

Charlotte Foust

-----Original Message-----
From: Drew Wutka [mailto:DWUTKA at marlow.com] 
Sent: Wednesday, April 16, 2003 2:02 AM
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


More information about the AccessD mailing list