<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2654.45">
<TITLE>RE: [AccessD] autonumber</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2><If so, check the archives on why this is a</FONT>
<BR><FONT SIZE=2>cardinal sin.></FONT>
<BR><FONT SIZE=2>But first make sure you have LOTS of bandwidth to download the "discussions" ;-)</FONT>
<BR><FONT SIZE=2>Jim Hale</FONT>
</P>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Wortz, Charles [<A HREF="mailto:CWortz@tea.state.tx.us">mailto:CWortz@tea.state.tx.us</A>]</FONT>
<BR><FONT SIZE=2>Sent: Wednesday, April 16, 2003 7:46 AM</FONT>
<BR><FONT SIZE=2>To: accessd@databaseadvisors.com</FONT>
<BR><FONT SIZE=2>Subject: RE: [AccessD] autonumber</FONT>
</P>
<BR>
<P><FONT SIZE=2>John,</FONT>
</P>
<P><FONT SIZE=2>I cannot let this pass without asking why do you care? You are not</FONT>
<BR><FONT SIZE=2>committing the cardinal sin of allowing you users to see the autonumber</FONT>
<BR><FONT SIZE=2>field are you? <grin> If so, check the archives on why this is a</FONT>
<BR><FONT SIZE=2>cardinal sin.</FONT>
</P>
<P><FONT SIZE=2>Charles Wortz</FONT>
<BR><FONT SIZE=2>Software Development Division</FONT>
<BR><FONT SIZE=2>Texas Education Agency</FONT>
<BR><FONT SIZE=2>1701 N. Congress Ave</FONT>
<BR><FONT SIZE=2>Austin, TX 78701-1494</FONT>
<BR><FONT SIZE=2>512-463-9493</FONT>
<BR><FONT SIZE=2>CWortz@tea.state.tx.us</FONT>
</P>
<BR>
<BR>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Drew Wutka [<A HREF="mailto:DWUTKA@marlow.com">mailto:DWUTKA@marlow.com</A>] </FONT>
<BR><FONT SIZE=2>Sent: Wednesday 2003 Apr 16 05:02</FONT>
<BR><FONT SIZE=2>To: 'AccessD@databaseadvisors.com '</FONT>
<BR><FONT SIZE=2>Subject: RE: [AccessD] autonumber</FONT>
</P>
<P><FONT SIZE=2>A make table query should already 'reset' the AutoNumber, since it is</FONT>
<BR><FONT SIZE=2>going to make a new table. An append query can be used to 'set' numbers</FONT>
<BR><FONT SIZE=2>within an AutoNumber field, however, it doesn't reset the counter, it</FONT>
<BR><FONT SIZE=2>can just 'ignore' it. If you delete the data in a table, to resent the</FONT>
<BR><FONT SIZE=2>AutoNumber counter, compact the database. It will reset the counter (on</FONT>
<BR><FONT SIZE=2>an incremental</FONT>
<BR><FONT SIZE=2>AN) to the highest number plus 1 (or 1, if there are no records</FONT>
<BR><FONT SIZE=2>remaining).</FONT>
</P>
<P><FONT SIZE=2>Drew</FONT>
</P>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: John Eget</FONT>
<BR><FONT SIZE=2>To: AccessD@databaseadvisors.com</FONT>
<BR><FONT SIZE=2>Sent: 4/16/03 4:43 AM</FONT>
<BR><FONT SIZE=2>Subject: [AccessD] autonumber</FONT>
</P>
<P><FONT SIZE=2>Is there a way to reset the autonumber to 1 of a make table query or an</FONT>
<BR><FONT SIZE=2>append or a table I just finished deleting the information from? John</FONT>
<BR><FONT SIZE=2><<ATT46269.txt>> </FONT>
<BR><FONT SIZE=2>_______________________________________________</FONT>
<BR><FONT SIZE=2>AccessD mailing list</FONT>
<BR><FONT SIZE=2>AccessD@databaseadvisors.com</FONT>
<BR><FONT SIZE=2><A HREF="http://databaseadvisors.com/mailman/listinfo/accessd" TARGET="_blank">http://databaseadvisors.com/mailman/listinfo/accessd</A></FONT>
<BR><FONT SIZE=2>Website: <A HREF="http://www.databaseadvisors.com" TARGET="_blank">http://www.databaseadvisors.com</A></FONT>
</P>
</BODY>
</HTML>