Compact Repair Problem

[Ukraine82]

Hey,

My compact and repair recently been giving me a problem with my AutoNumber(primary key).

I have a quiz made for every department in my company, I'm sure you all aware once the information is being typed in a form AutoNumber(primary key)set a new number.

I've compact and repair the database and it giving me a duplicate autonumber. Why??? and How do I stop it????

Thanks,
Michael

 

[RoyVidar]

Seems like it could be this bug?

http://support.microsoft.com/?scid=kb;en-us;884185

 

[Ukraine82]

Seems like it could be this bug?

http://support.microsoft.com/?scid=kb;en-us;884185

Not the answer I wanted to hear, but thanks I kind of figured my database was some what corrupted.

Michael

 

[RoyVidar]

I don't think it's corruption, just a bug you can handle by following the method described by Microsoft (compact the database, then reseed (or reset or whatever term one wishes to use) the autonumber)