Converted FM5 to FM11 to FM 17. I essentially rewrote the application as part of the effort and am experiencing database issues. Here's one. A primary key field that is defined as auto-enter serial number will jump to numbers out of sequence.
I suspect that the data should be exported and then re-imported into an initialized copy of the table. That cannot hurt.
Has anyone had experiences like this in moving from an old version to a newer one?
All I ran was a DB Verify and that was fine.
All thoughts are welcomed.