Autonumber

[nhtraven]

I have an autonumber field that i changed the starting value. Well, now i need to change the starting value to a lower number and cannot do that. I have tried to delete the field, and that hasnt worked. I am to point were i am going to have to scrap this database and start over. Any help is appreciated.

Thanks

Raven

 

[nhtraven]

Sorry all

I figured it out, i had to compact and repair database to reset autonumber.

 

[knownote]

nhtraven,

Try this on a copy of your database.
To absolutely reset an autonumber field: If the autonumber
is a part of a relationship as a primary or foreign key,
delete (temporarily) the relationship. Next, open the
table in design view. Select the field. If a primary key,
deselect key icon. Cut (NOT Delete) selected autonumber
field, insert a blank row, and paste autonumber field back
again. Save and close table.

Repeat for related table(s) if
other autonumbers involved to reset them also (otherwise
these related autonumber fields may not match up). Finally,
restore relationship as it was a few minutes ago.

Hope this was helpful.
John