Lost Records Due To Power Cut

Hi All,

We've just had a power cut and 2 of us were in the process of adding a record to the database. The primary field is an Autonumber and, on re-entering the information for the record, we have found that 2 numbers are missing.

Ie. instead of record numbers 1,2,3,4, we now only have 1 & 4. Is there any way of retrieving 2 & 3?

And is there something I can/should do in order to prevent this problem from reoccuring?

We have the Autonumber facility so that, when we add a new record, it automatically enters the next number. Is there a formula I can use so that the default value when adding the record is the number of the previous record + 1?

With thanks for any assistance.

Ronnie