John Frederick
j.frederick at att.net
Thu Apr 17 13:45:29 CDT 2003
Using the IDE, 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. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of John Eget Sent: Wednesday, April 16, 2003 5:44 AM To: AccessD at databaseadvisors.com 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 -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030417/052a0acc/attachment-0001.html>