compacting database doesn't reset autonumber (ver 2000)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JulieD - 24 Jan 2005 15:05 GMT

Hi All

this is the first time ever that i've experienced a situation where deleting
a couple of records (ID 3 & 4, leaving ID 2 as the highest number) and then
compacting the database HASN'T reset the autonumber ID of the next new
record back to 3 ... but i had 6 machines today that all put the next record
in at #5. They were all Access 2000 machines running SR-1.

Any ideas on why compacting the database didn't reset the autonumber, and
more importantly, any ideas on how to re-set the autonumbers now?

BTW there is no data in any of the other tables - just this one.

Cheers
JulieD

Reply to this Message

JulieD - 24 Jan 2005 16:13 GMT

don't worry - found answer

http://support.microsoft.com/default.aspx?scid=kb;en-us;q287756

Cheers
JulieD

> Hi All
>
[quoted text clipped - 12 lines]
> Cheers
> JulieD

Reply to this Message

anonymous@discussions.microsoft.com - 24 Jan 2005 16:16 GMT

access auto numbers don't reset. period.
this is the problem access auto number usually caused by
deleting records.(a no-no. you should mark the records
somehow ie open, complete, canceled, inactive, active,
other, ect. this also prevents gaps in the number sequence)

>-----Original Message-----
>Hi All
[quoted text clipped - 14 lines]
>
>.

Reply to this Message

JulieD - 24 Jan 2005 16:25 GMT

have a look at the link i posted .. .it is actually called a "BUG" my MS ...
in this case we are entering test data and want to be able to delete the
data when the database is finished to put it into production - therefore we
would like to reset the IDs.

Cheers
JulieD

> access auto numbers don't reset. period.
> this is the problem access auto number usually caused by
[quoted text clipped - 28 lines]
>>
>>.

Reply to this Message