Re: Problem with AutoNumber

Tech-Archive recommends: Fix windows errors by optimizing your registry

Nikos,

I checked the underlying table but forgot to mention that the autonum field
was set to 'new values - increment'

and the strange thing was, that it worked over the past months ...

I interpreted this behavior as 'some kind of corruption' ....
question here to Access: WHERE and HOW ?:-(
a compress & repair with the data in it didn't do any changes to the better
..... and that really gave me a headache
from posts here my idea was to go the radical way ... which was good

Thanks for your help!!

Gina

"Nikos Yannacopoulos" <nyannacoREMOVETHISBIT@xxxxx> schrieb im Newsbeitrag
news:%238h0F57dFHA.1448@xxxxxxxxxxxxxxxxxxxxxxx
> Beats me! If it's autonumber with its New Values property not set to
> random, I can't think of any possible reason why this should happen...
> except maybe corruption? If that's the case, then what you did took care
> of it.
>
> Regards,
> Nikos


.