[RESOLVED] Quick Database Backup Question. I Hope.

[eXhumed]

Hi Again,

In VB6 Is There Any Way To Backup A Database (*.mdb), But Let The User Choose Where To Save It?

I Tried To Find Something About Showsave (I Heard It Somewhere Along The Line), But I Do Not Know How To Impliment It.

Please Help,

Michael.

[Al42]

How about just copying the file? Use CommonDialog Open and Save boxes to let the user choose the database (if the program doesn't already know the name), or just use directory and folder controls to let the user choose the save location.

[Hack]

Hi Again,

In VB6 Is There Any Way To Backup A Database (*.mdb), But Let The User Choose Where To Save It?

I Tried To Find Something About Showsave (I Heard It Somewhere Along The Line), But I Do Not Know How To Impliment It.

Please Help,

Michael.

You need to close the database before backing it up. Then, as Al42 has already said, you can use the commondialog1 control to allow the selection of the backup folder.

Question: Does everyone using your application have the permissions to do a backup? If so, this could lead to backup copies of your MDB spread out all over the place. I would suggest you restrict the ability to do this to only an application administrator. That way, you would always know where the backup copy is.