Resetting Auto Count/Increment

[t5amec]

I'm redeveloping a DB for a new project, so have removed all previous records from relevant tables (to start a-fresh)

One snub, the ID fields in the tables are auto increasing from where they left off, rather than from 1

If anyone knows how to reset the auto counters, it would be very much appreciated

Thanks in advance

 

[ColinEssex]

Why bother?

The AutoNumber is purely a method of linking tables, it's not used for anything else (or shouldn't be) so it doesn't matter what number it is, nobody sees it.

Col

 

[neileg]

I agree with Colin. However a Compact & Repair will reset an autonumber on an empty table.

 

[ajetrumpet]

t5amec,

this should tell you everything you need to know....

http://support.microsoft.com/kb/812718

 

[t5amec]

Hi All,
Thank you for your replies yesterday, the problem has now been solved