Restoring a backup in access (forms)

[Earplug]

Hello all!

In our forms, we have managed to export a backup of our application (to accdb file) in a specific folder.

We now are trying to make a backup restore function that restores the backup (the accdb file).
However, we have some difficulties with restoring this backup in a form (like browsing for this specific backup file).

Any tips on how to make this restore function?

Thank you!!

 

[DavidAtWork]

Is the database split, FE & BE and you want to restore just the BE, if so I can think of a way to do this, method in simple terms would be:
Delete all tables linked to BE,
use the msoFileDialogFilePicker method to get user to select the backup file
copy the selected file to BE destination, overwriting existing BE
relink all tables linked to BE

If your database is not split, I don't see how you could overwrite while the database is itself open, you could do it from another database

David