[mso] Re: Changing auto numbers in an access table

Do a Compact & Repair (Tools/Database Utilities menu).

This will take you back to the last number used. Ie if you still have 10
records in your list, your next one will be 11.

If you have any gaps in your numbering of the existing records, you will
have to delete the Auto number, then add it again.


Colin

**************************************
Colin McDonald
colinmac@xxxxxxxxxxxxxxxx
**************************************


-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of Paul J. Traynor
Sent: 25 October 2002 16:10
To: mso@xxxxxxxxxxxxx
Subject: [mso] Changing auto numbers in an access table



Hi,

I have been experimenting with tables and forms and am now ready to use
a table I earlier created which has an auto number ID preceding each
record.  What I have noticed however is that  while I deleted the old
records and have begun to insert new entries the auto number is
continuing on  from where it finished  with the old records.  For
example if I had  10 records before and wiped them off and started over
again the auto number is seeing the first of my new records as "11".

How can I reset this so that it reflects the  number of new records in
my table.

Many thanks,

Paul.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.404 / Virus Database: 228 - Release Date: 15/10/2002
 

*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx
or MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx?Subject=unsubscribe

Or, visit the group's homepage and use the dropdown menu.  This will
also allow you to change your email settings to digest or vacation (no
mail). http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group,
send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an
invitation with instructions.  Once you are a member of the files group,
you can go here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx?Subject=unsubscribe

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

Other related posts: