Indexes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...
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?
 
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
Click to expand...
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?
 
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
 
OOPs! Thanks Kevin for the warning
Tony
Kevin3NF said:
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
Click to expand...
 
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
Click to expand...
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?
 
Back
Top