auto-number madness

[stevehooley]

Hi everyone, i hope all is well.

In one of my databases, an auto-number field seems to have reset itself without manual intervention (e.g appending a long integer value). Does anyone have any suggestions for how this may have happened?

 

[KenHigg]

You mean it started back at 1?

Ken

 

[Mile-O]

You compacted a database with an empty table, most likely.

 

[stevehooley]

that could be it, thanks for your help.