Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access_asp thread: How can I restart autonumber field?


Message #1 by "Elildo Mancebo Reis" <lists@a...> on Sat, 28 Dec 2002 12:20:22 -0200
Hi, all!

After testing my pages I want to delete all records and set autonumber field
"seed" to 1. How can I do it in Access?

Message #2 by "Carl E. Olsen" <carl-olsen@m...> on Sat, 28 Dec 2002 08:35:08 -0600
Copy the table and paste it into access.  Delete the original table and
then rename the copy to the name of the original.

> -----Original Message-----
> From: Elildo Mancebo Reis [mailto:lists@a...]
> Sent: Saturday, December 28, 2002 8:20 AM
> To: Access ASP
> Subject: [access_asp] How can I restart autonumber field?
> 
> Hi, all!
> 
> After testing my pages I want to delete all records and set autonumber
> field
> "seed" to 1. How can I do it in Access?
> 
> 
> to unsubscribe send a blank email to leave-access_asp-
> 1112135Q@p...


Message #3 by "bwarehouse" <bwarehouse@y...> on Sat, 28 Dec 2002 18:40:37 -0700
Delete all records, compile the database, close db, reopen db.


Later,
bware

-----Original Message-----
From: Elildo Mancebo Reis [mailto:lists@a...]
Sent: Saturday, December 28, 2002 7:20 AM
To: Access ASP
Subject: [access_asp] How can I restart autonumber field?

Hi, all!

After testing my pages I want to delete all records and set autonumber field
"seed" to 1. How can I do it in Access?





  Return to Index