reset an auto number

[jgmills]

Hey all,

I have an auto number and with testing etc it is no longer set at 0. So when i make the thing live/hand it over to client, i would like the auto number to be back at 0....

Any ideas how to reset it?

Thanks

 

[Darrylles]

Hi,

1) Why do you want the autonumber back at zero? The client will NEVER EVER see it. (If they can, then they shouldn't).

2) I believe, that by deleting all records from the table with the autonumber (probably already empty), and 'Compacting & Repairing' your database - this will re-set the empty table '1st subsequent autonumber value' to 1.

3) If 2) above doesn't work, then:
Rename your table.
Copy n paste the table (structure only - no data) to
your original table name. This in effect creates a
brand new table.

ATB

Darrylle




ATB

Darrylle

Never argue with an idiot, he'll bring you down to his level - then beat you with experience. darrylles@yahoo.co.uk

 

[Darrylles]

p.s. How many ATB / Darrylle do I need??????

Never argue with an idiot, he'll bring you down to his level - then beat you with experience. darrylles@yahoo.co.uk

 

[jgmills]

Great, yes thats right, i remember now, 'Compacting & Repairing' thats does it!

Thanks