Undelete a record.

[brianholmbeck]

I have a table that users Autonumber. A user started to
take out the next number (4226) but then hit Undo, which
deleted the record. If they try to take the number out
again it skips the the next Autonumber 4227. So it goes
4224, 4225, 4227, 4228, etc. How can I get 4226 back? The
only solution I've found is to create a new blank table,
enter 4225 blank records (boy is that monotonous), copy
the first 4225 records from the old one and paste them in
the new one, add record 4226 and flag as "available", then
copy records from 4227 to the last record and paste in the
new table.

 

[Shawn]

First you must compact and repair database. Go to
TOOLS>DATABASE UTILITIES>COMPACT AND REPAIR DATABASE
then resave your table as "copy of "your table"" then
delete original table and rename "copy of "your table"" to
your original name and compact and repair database again.
Now your next record should be 4226. It sounds
complicated, but it's pretty easy.
Shawn

 

[Shawn]

Sorry, but what I wrote will only work if 4225 was your
last record. Once youve deleted a number in the middle of
other numbers, that number is gone.
Shawn