re-initialising the table data

[sthapa]

Hi All

weve had a database built recently and have been doing substanial testing.
I was wondering if there was a way to refresh everything so all the relevent ID numbers start from 1 rather than 14211

Thanks

 

[maxmangion]

copy the table and paste it with a different name. Delete the original table and rename the pasted table to the original name of the table

 

[Rich]

Or just delete the Records and then compact the db

 

[maxmangion]

Or just delete the Records and then compact the db

But doing it this way, you still do not get autonumbers to start at 1.

 

[Rich]

You do in 97

 

[maxmangion]

i did not know that ... strange that such a feature does no longer function in Access 2000.

 

[sthapa]

thanks for the resolution guys

I tried the first method, but because of all the relationships the table could not be deleted. Compacting the database did the trick.

Im using Access 2000

Thanks a lot