Private Sub mnuDBbackup_Click() '备份数据库 Dim fs Set fs = CreateObject("Scripting.FileSystemObject") If fs.FileExists(App.Path & "\backup\dbbackup.mdb") Then fs.DeleteFile App.Path & "\backup\dbbackup.mdb" fs.copyfile App.Path & "\mlc.mdb", App.Path & "\backup\dbbackup.mdb" MsgBox "备份完成!", 64, "数据库备份情况" End SubPrivate Sub mnuDBrestore_Click() '恢复数据库 Dim fs Set fs = CreateObject("Scripting.FileSystemObject") dbs.Close If fs.FileExists(App.Path & "\mlc.mdb") Then fs.DeleteFile App.Path & "\mlc.mdb" fs.copyfile App.Path & "\backup\dbbackup.mdb", App.Path & "\mlc.mdb" Set dbs = OpenDatabase(App.Path & "\mlc.mdb") MsgBox "已恢复上次备份!", 64, "数据库恢复情况" End Sub
FileCopy App.Path & "\mdb\rsgzmdb.mdb ", "a:\rsgzmdb.mdb"
Me.MousePointer = 0
MsgBox "数据库已备份完毕,请一定将软盘保存好!", vbInformation + vbOKOnly
mdifrmgzgl.StatusBar1.Panels(2).Text = ""
如果你有好方法,请告诉我,谢谢。
哦,这样!
但能不能用sql 语句来备份和恢复数据库呢?怎样用backup和 restore这两个sql语句,在vb中不能直接嵌套这两个sql语句。
Dim fs
Set fs = CreateObject("Scripting.FileSystemObject")
If fs.FileExists(App.Path & "\backup\dbbackup.mdb") Then fs.DeleteFile App.Path & "\backup\dbbackup.mdb"
fs.copyfile App.Path & "\mlc.mdb", App.Path & "\backup\dbbackup.mdb"
MsgBox "备份完成!", 64, "数据库备份情况"
End SubPrivate Sub mnuDBrestore_Click() '恢复数据库
Dim fs
Set fs = CreateObject("Scripting.FileSystemObject")
dbs.Close
If fs.FileExists(App.Path & "\mlc.mdb") Then fs.DeleteFile App.Path & "\mlc.mdb"
fs.copyfile App.Path & "\backup\dbbackup.mdb", App.Path & "\mlc.mdb"
Set dbs = OpenDatabase(App.Path & "\mlc.mdb")
MsgBox "已恢复上次备份!", 64, "数据库恢复情况"
End Sub
好啊,我想要这个控件,告诉我下载的网址好吗。
我的email:[email protected]
谢谢