reset primary key

[emilylu3]

Is there a way to reset the primary key back to starting with 1, of course i would delete all existing recordset. I can do it by deleting the key and re-keying, but there seems liek there should be a way.



Thanks

[StepUP]

Well the quick and dirty way to do that is to go into the design of the table and delete the key field (I'm assuming its an "auto number" field), save it, then add the field back in.

However, it you have relationships with other tables with a foreign key relating to the primary, you should rename the primary key field and change its type to Long Integer, create a new auto number field with the original primary field name, and then you would have to create an update query that updates the foreign key with the new field. If you have a relationship defined with referential integrity, would have to delete that first before going through this process and then reestablish it.