Autonumbers

[jon jomaco]

Hi. This is probably a stupid question but it is becoming annoying trying to figure it out.

I have created two linked tables and then created forms to enter information into them. While i was working i tested several pieces of information by entering information into the tables and forms. Now i am ready to start importing the intial data and the autonumber is at 13 for one table and around 6 or 7 for the other one.

Is there any possible 'easy' way, without creating the whole tables or forms again, that i can reset the autonumbers to start at 1 again?

Thanks, any information appreciated.
Jon.

 

[ghudson]

If the table is empty... You can compact the db and the autonumbers should reset.

Also, you can cut the field out of the design of the table, save the table, then paste the field back into the design of the table to reset the autonumbers.

 

[asdaqamin]

There is an easy way for this problem.

You have copy the desired table in which you want to start the Original data want to enter.
Suppose you have a table named "Personal" in which u do testing. Now Right Click the "Personal" Table & copy it.and then paste on the the tables white area.The dialog appears New Name "Personal1" paste option Structure only.
same fields are created there in Personal1.

Now Personal table is renamed by some other name. Such as PersonalOld.
Change name of Personal1 as Personal.

Thats all.

 

[jon jomaco]

A 2 year late reply but many thanks guys. Your efforts will not go to waste as this will come in useful for the current project i am working on
Jon.