Hi! I have a simple newbie question.

I just made my first database application, I'm currently using VB6 and access 97. I want to be able to save and restore backups of the database. What's the best way of doing this?

Is is possible for the user of my program to be able to save the database in a different directory and/or different name? Similar to saving a word document file. I also want the user to restore/open any database saved by the application. Similar to opening a word document.

Is this the right approach in doing this? Or is there a better way?

Thanks in advance for all the help