<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1141" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=406594018-17042003><FONT face=Arial color=#0000ff size=2>Using
the IDE, </FONT></SPAN><SPAN class=406594018-17042003><FONT face=Arial
color=#0000ff size=2>copy the table, paste selecting the "Structure Only"
option and tacking on x onto the name to make it unique. Then delete the
old one and take the x off the name of the new one. I don't know how to do
it in code.</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com]<B>On Behalf Of </B>John
Eget<BR><B>Sent:</B> Wednesday, April 16, 2003 5:44 AM<BR><B>To:</B>
AccessD@databaseadvisors.com<BR><B>Subject:</B> [AccessD]
autonumber<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>
<DIV><FONT face=Arial size=2>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?</FONT></DIV>
<DIV><FONT face=Arial
size=2>John</FONT></DIV></FONT></DIV></BLOCKQUOTE></BODY></HTML>