Restore From BackUp

[ddrew]

Having split my DB, I have now made a button that backsup/copies the BE to a backup folder. It copies the database name and puts the date of the backup on the end (GundogTraining_be 18 01 12). What I need to do now is create an Import function. Where the user would select the button which would open the folder "BackUp" they would then choose the file to import.And the file would be imported into its "Working" directory and automatically renamed ie. GundogTraining_be

Not really sure how to go about this, this is what I am using to open the BackUp Dir, but after this I'm stuck!

Private Sub btn_Import_Click()

    Shell "EXPLORER.EXE C:\Gundog Training Databases\BackUp\", vbNormalFocus

End Sub

 

[gemma-the-husky]

out of interest ... why would you want to be restoring backups as a matter of course

 

[ddrew]

If Im changing the front end, the records will remain the same or if the user reinstalls on a different machine.