Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Computer Certification > MCAD > How to reset the Autonum field?

Reply
Thread Tools

How to reset the Autonum field?

 
 
Nicolas Boucquey
Guest
Posts: n/a
 
      01-04-2004
I work with Access 2002. And I want to reset the Autonum
field to deliver my application.
How to reset the Autonum field?
I tried with the method described in the Access Help
pages. This method works fine to intialize the Autonum
field to a greater value but not to reste the value to
Zero.

Many thanks in advance.

Nicolas
 
Reply With Quote
 
 
 
 
Kael V. Dowdy
Guest
Posts: n/a
 
      01-05-2004
"Nicolas Boucquey" <(E-Mail Removed)> wrote in message news:<042a01c3d2b6$9daa4b50$(E-Mail Removed)>...
> I work with Access 2002. And I want to reset the Autonum
> field to deliver my application.
> How to reset the Autonum field?
> I tried with the method described in the Access Help
> pages. This method works fine to intialize the Autonum
> field to a greater value but not to reste the value to
> Zero.
>
> Many thanks in advance.
>
> Nicolas


If you purged all records from the table that has the autonumber,
simply compact and repair the table. That will reset the autonumber.
(easy fix!)

Kael MCSD
 
Reply With Quote
 
 
 
 
Kael V. Dowdy
Guest
Posts: n/a
 
      01-05-2004
"Nicolas Boucquey" <(E-Mail Removed)> wrote in message news:<042a01c3d2b6$9daa4b50$(E-Mail Removed)>...
> I work with Access 2002. And I want to reset the Autonum
> field to deliver my application.
> How to reset the Autonum field?
> I tried with the method described in the Access Help
> pages. This method works fine to intialize the Autonum
> field to a greater value but not to reste the value to
> Zero.
>
> Many thanks in advance.
>
> Nicolas


Sorry, I meant "...compact and repair the database"
 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: How include a large array? Edward A. Falk C Programming 1 04-04-2013 08:07 PM
You will not be able to reset the access - can't reset. jc MCAD 0 12-09-2007 08:58 PM
CISCO 7XX / 761 password reset or reset to factory defaults Philipp Flesch Cisco 3 06-18-2006 07:47 PM
Connection Reset =?Utf-8?B?RGljb3Jwbw==?= Wireless Networking 0 10-08-2004 03:35 PM
Wireless Linksys Router Reset--What happened? =?Utf-8?B?TW9yZGlkbw==?= Wireless Networking 1 10-08-2004 11:28 AM



Advertisments