[AccessD] Reset Autonumber (WAS: Autonumber Assigned Immediately)

John, 

Yes, it works for tables with data. The only requirement is that the
starting value must be 1 higher than the highest autonumber value
already in the table, to aviod duplicate values. 

Also, if your autonumber field is set to random values, you are pretty
much stuck with that. I wouldn't reset the autonumber value in that
circumstance.

-Ken

-----Original Message-----
From: John W. Colby [mailto:jwcolby at colbyconsulting.com] 
Sent: Friday, September 09, 2005 12:56 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Reset Autonumber (WAS: Autonumber Assigned
Immediately)

Ken,

Does this method work for tables with data already in them, or only
empty tables?

John W. Colby
www.ColbyConsulting.com