Restore MDB File from Backup

[alicampbell]

Is it possible within a VB6.0 database application using an MDB database to add a procedure to restore (overwrite) a file which has been backed up to a floppy. I have a menu button which backs up to the floppy, but can only restore with a batch file from DOS. This seems a clutzy solution, but I can't find a better one.

[Clunietp]

I've used the FileCopy function and that works fine for me....just release all connections to your database before you restore the MDB file

[alicampbell]

Thanks 'Guru'. I'm embarrassed to say I don't know how to release all connections to my database!