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 Sub
Private 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