I searched the forum but could not find help on this.

My backup module keeps a copy of the mdb file (backend) in Backup folder adding date and time of backup. So far no corruption has taken place but if it happens, what I would like to do is to identify the last uncorrupted backup and restore the data from it. I can do this manually, first delete the corrupted data, select the table from the backup and run the append query. Can this be done with code where a window shows the backup files to choose and then appends the data?

You can use an API call to open the File Browser dialog window to choose the file to restore from, but I am unclear on the method you're using to determine which file has uncorrupted data. Do you open the backup files manually to check its contents?

Thanks for your quick response
My backups are named 'Backup-MyMDBName-CurrentDate-CurrentTime' so that it is easy to identify the backup file that funtioned well by date and time.

Very well, here's a link to that API code I was telling you about. HTH