Gail said:
I have deleted a record in a database table and i need to recover it.
Is there any way as the autonumber sequence is now out of order.
BEEEP If you are concerned about an autonumber out of order, you are
not using the proper tool.
I suggest you may not want to use Autonumber for that use. Autonumbers
are designed to provide unique numbers. It in not designed to provide
numbers in order and for a number of reasons may not do so. As a result
using them in any application where the user sees the numbers is likely to
end up with confusion.
There are other ways of providing the numbers you want depending on the
particual application.
To do what you asked to do (not what you should do) make a new table
using the copy existing table technique and copy just the description not
the date. Then use an append query to populate the new table with the data
from the old table (do not copy the auto number? - play with this I forget
this part of the procedure) then delete the original table and rename the
new one.
Follow this up with a compact of the database.
As always make a copy of your database first.
