Private Sub BackUpDatabase()
Dim strBackUpPath As String
Dim intBackUpFiles As Integer
Dim strDBFileName As String
Dim i As Integer
Screen.MousePointer = 11
strBackUpPath = "d:\backup\"
intBackUpFiles = 5
strDBFileName = "袁飞库" '数据库文件名(不包括路径与扩展名)
For i = intBackUpFiles To 2 Step -1
name (strBackUpPath & strDBFileName & "." & i - 1 & ".bak") as (strBackUpPath & strDBFileName & "." & i & ".bak")
Next
fileCopy "袁飞库.mdb", strBackUpPath & strDBFileName & ".1.bak" Screen.MousePointer = vbDefault
End Sub
Dim strBackUpPath As String
Dim intBackUpFiles As Integer
Dim strDBFileName As String
Dim i As Integer
Screen.MousePointer = 11
strBackUpPath = "d:\backup\"
intBackUpFiles = 5
strDBFileName = "袁飞库" '数据库文件名(不包括路径与扩展名)
For i = intBackUpFiles To 2 Step -1
name (strBackUpPath & strDBFileName & "." & i - 1 & ".bak") as (strBackUpPath & strDBFileName & "." & i & ".bak")
Next
fileCopy "袁飞库.mdb", strBackUpPath & strDBFileName & ".1.bak" Screen.MousePointer = vbDefault
End Sub
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货