does anyone know how to retrieve deleted data in rows?

[Guest]

i have deleted an enitre row of data. i cannot simply add it to the bottom of
the datasheet considering it is in order. for example i need to add the ID #6
before the ID #7.

 

[ruralguy via AccessMonster.com]

That is simply a sorting issue. Access tables are really a bucket of records
that Jet will return in a manner it consideres the fastest. The records are
not necessarly returned in the order they were created. Just put an OrderBy
clause in your query.

 

[John Vinson]

i have deleted an enitre row of data. i cannot simply add it to the bottom of
the datasheet considering it is in order. for example i need to add the ID #6
before the ID #7.

Are you using a Datasheet in Excel? or a Table in Access? If the
former, just use the Insert menu option to insert a row.

If you have an Access Table with an autonumber ID, you'll need to run
an Append query to append the data, appending a long integer value 6
into the autonumber field; and you'll need to use a Query to sort the
data. Tables ARE NOT SPREADSHEETS and autonumbers are *not* guaranteed
to be sequential or gapless, and they should *not* be used as you are
using them: only as a unique, meaningless identifier.

John W. Vinson[MVP]

 

[dbahooker]

use a TRIGGER and ACCESS DATA PROJECTS you MDB _WIMP_

 

[Tom]

The meaning of an identifier is that it "identifies". So regardless of
whether it's meaningless or not, an identifier still has significant
meaning. <g>