how recover deleted records from a acess database?

[jason213123]

hi,
there is any way to recover deleted records from a acess database?
thanks a lot for your help
:)

[Paul Komski]

Not to my knowledge unless you had created a cusomised deletion regime by using a yes/no field as a deleted marker. This is commonly done to allow for full audit trails in accounting packages.

I believe that whole Tables and Queries can be undeleted if a database has not been compacted but not individual records; once they are gone - that's that.

Your only chance would be if there is another earlier copy of the whole .mdb file backed-up somewhere or that was shifted around in the underlying data. You could try searching for such "duplicates" with GetDataBack (for FAT or NTFS as appropriate) but I wouldn't hold up much hope I'm afraid.

[classicsoftware]

Just another reason to use FoxPro (http://msdn.microsoft.com/en-us/library/a0tf56y8%28VS.80%29.aspx) instead of Acesss.

Access was the poor step child in the database world until MS purchased Fox Software to get their Rushmore technology.

[Paul Komski]

We all have our own favourites but personally I wouldn't touch FoxPro with a barge pole. All databases have their pros and cons. However the first rule with respect to any valuable data is the old mantra of keeping full or differential back-ups on a schedule that suits ones needs. Foxpro does allow full deletion of its records - but in a two-phase operation like a recycle bin or trash folder in an email client - so customising a FoxPro application is still required to allow for full audit trails.

[classicsoftware]

We all have our own favourites but personally I wouldn't touch FoxPro with a barge pole. All databases have their pros and cons. However the first rule with respect to any valuable data is the old mantra of keeping full or differential back-ups on a schedule that suits ones needs. Foxpro does allow full deletion of its records - but in a two-phase operation like a recycle bin or trash folder in an email client - so customising a FoxPro application is still required to allow for full audit trails.

But at least you can recover a record. The problem with Access is if the deletion occurs at the end of the day, you have to lose that days work to go back to the last backup. What application makes a huge data-file backup each time a change is made?

Just keep in mind Access would still be a zero without FoxPro. It's the Fox technology that allowed Access to flourish.