I always thought that an Autonumber field in an access table always incremented and was not possible to reset it (not easily anyway).

I expect you can guess what I'm going to say now...


THE F****** AUTONUMBER KEEPS RESETTING ITSELF!

Of course this only happens on the customer's PC and always works fine on our development PCs

VB5 front end
Access 97 database

Any ideas why?


------------------
Mark Sreeves
Analyst Programmer

[email protected]
A BMW Group Company