I have an Access 2007 front end tied to a MS SQL Server 2014 back end. One of the tables is basically an inventory list. The primary key is an INT, is identity, increment 1. At the end of the day on Thursday (07-02) the ID count is up to 965. This morning (07-06) I add a line item and I am at ID 1958. Nobody with access to the database was in the office over the weekend. I see a reference to "pages dumped: 506" during a backup that occurred on 07-04 and 07-05 in the logs.
This does not make sense to me. It almost looks like someone copied 992 records, pasted them, realized the error and then deleted them. Any other possibilities here?