Indexes

[Tony Williams]

How do you set the indexes back to starting at 1. I have a number of tables where I have been adding and deleting records but for the sake of clarity I would like to start all the indexes as 1 and renumber all the records. Can this be done?
TIA
Tony

 

[jmonty]

First, open your table in design mode.
It sounds like your "index" field is an Autonumber. If
this is the case, you can reset them by right-clicking,
then deleting this field, and saving the table. Then right-
click again and insert a row and use the same name, and
change the type to Autonumber. Save the table again and
Access will renumber the field starting at 1.

-----Original Message-----
How do you set the indexes back to starting at 1. I have

a number of tables where I have been adding and deleting
records but for the sake of clarity I would like to start
all the indexes as 1 and renumber all the records. Can
this be done?

 

[Tony Williams]

Thanks that sounds pretty srtaight forward!
Tony

----- jmonty wrote: -----

First, open your table in design mode.
It sounds like your "index" field is an Autonumber. If
this is the case, you can reset them by right-clicking,
then deleting this field, and saving the table. Then right-
click again and insert a row and use the same name, and
change the type to Autonumber. Save the table again and
Access will renumber the field starting at 1.

-----Original Message-----
How do you set the indexes back to starting at 1. I have

a number of tables where I have been adding and deleting
records but for the sake of clarity I would like to start
all the indexes as 1 and renumber all the records. Can
this be done?

 

[Kevin3NF]

Unless you are using that field as a primary key and relating it to other
tables, in which case deleting the field will either fail, or screw up the
relationships throughout your db.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

 

[Tony Williams]

OOPs! Thanks Kevin for the warning
Tony

Unless you are using that field as a primary key and relating it to other
tables, in which case deleting the field will either fail, or screw up the
relationships throughout your db.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

 

[Jim/Chris]

Remove all the records and compact the database.

Jim

-----Original Message-----
How do you set the indexes back to starting at 1. I have a

number of tables where I have been adding and deleting
records but for the sake of clarity I would like to start
all the indexes as 1 and renumber all the records. Can this
be done?