By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,510 Members | 1,810 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,510 IT Pros & Developers. It's quick & easy.

how to take run time database backup using visual basic 6.0

P: 13
Hi
How we can take run time database back using Visual Basic 6.0.
For SQL Server and Access database.
Sep 20 '07 #1
Share this Question
Share on Google+
2 Replies


QVeen72
Expert 100+
P: 1,445
Hi,

For access database, use FilesystemObject's File Copy to Copy the mdb file to a Back-Up Folder..

REgards
Veena
Sep 20 '07 #2

100+
P: 274
hi
you can design interface using using DriveListBox and DirListBox controls to specify destination and source of database you want to back up. the use follwing code: suppose text1.text contains path to source and text2.text contains destination path. Label1 be a control to display a message for successful backup creation.

Dim fso As New Scripting.FileSystemObject
fso.CopyFolder Text1.Text, Text2.Text, True
Label1.Caption = "backup created successfully at " + Text2.Text
Exit Sub


regards
farhana
Sep 21 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.