你试试这段代码,我以前做的。 Private Sub cmdBackup_Click() Dim Dbco As Database Dim DbName As String DbName = App.Path & "\mdd.mdb"
Set Dbco = OpenDatabase(DbName, False, False, "") On Error GoTo errEnd Dbco.Close Set Dbco = Nothing If Dir(App.Path & "\mdd_bak.dat") <> "" Then Kill App.Path & "\mdd_bak.dat" DBEngine.CompactDatabase DbName, App.Path & "\mdd_bak.dat" Else DBEngine.CompactDatabase DbName, App.Path & "\mdd_bak.dat" Set Dbco = OpenDatabase(DbName, False, False, "") Exit Sub errEnd: MsgBox Err.Description, vbCritical, "系统提示" End Sub
你试试这段代码,我以前做的。我上面的少写了句end if Private Sub cmdBackup_Click() Dim Dbco As Database Dim DbName As String DbName = App.Path & "\mdd.mdb"
Set Dbco = OpenDatabase(DbName, False, False, "") On Error GoTo errEnd Dbco.Close Set Dbco = Nothing If Dir(App.Path & "\mdd_bak.dat") <> "" Then Kill App.Path & "\mdd_bak.dat" DBEngine.CompactDatabase DbName, App.Path & "\mdd_bak.dat" Else DBEngine.CompactDatabase DbName, App.Path & "\mdd_bak.dat" End if Set Dbco = OpenDatabase(DbName, False, False, "") Exit Sub errEnd: MsgBox Err.Description, vbCritical, "系统提示" End Sub
SQL备份dB.Execute ("backup database " & strDataname & " to disk = ' " & strDataname & ".bak" & " '")
Dim key, list, SQL As String, NamStr As String Dim StrCnn As New ADODB.Connection Dim itmX As ListItem Dim dri As String Private Sub Command1_Click() NamStr = Dir1.Path & "\" & Trim(Text1.Text) & ".bak" If Text1.Text <> "" Then If Dir(NamStr) <> "" Then '判断文件是否已经有同名存在 MsgBox "数据库已经存在,请换其他名称!" Else StrCnn.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Data Source=wangguan" SQL = "backup database cgroup to disk = '" & NamStr & "'" '备份数据库 StrCnn.Execute (SQL) '执行SQL语句 StrCnn.Close MsgBox "数据库备份成功!", vbOKOnly + vbInformation, "提示" End If Else MsgBox "请输入文件名", vbOKOnly + vbInformation, "提示" End If End SubPrivate Sub Command2_Click() Unload Me End SubPrivate Sub Dir1_Change() Label1.Caption = Dir1.Path End SubPrivate Sub Drive1_Change() Dir1.Path = Drive1.Drive End SubPrivate Sub Form_Load() Label1.Caption = Dir1.Path End Sub
*****************************************************************************
欢迎使用CSDN论坛专用阅读器 : CSDN Reader(附全部源代码) http://feiyun0112.cnblogs.com/
????????????????????????????????
Private Sub cmdBackup_Click()
Dim Dbco As Database
Dim DbName As String DbName = App.Path & "\mdd.mdb"
Set Dbco = OpenDatabase(DbName, False, False, "") On Error GoTo errEnd
Dbco.Close
Set Dbco = Nothing If Dir(App.Path & "\mdd_bak.dat") <> "" Then
Kill App.Path & "\mdd_bak.dat"
DBEngine.CompactDatabase DbName, App.Path & "\mdd_bak.dat"
Else
DBEngine.CompactDatabase DbName, App.Path & "\mdd_bak.dat"
Set Dbco = OpenDatabase(DbName, False, False, "")
Exit Sub
errEnd:
MsgBox Err.Description, vbCritical, "系统提示"
End Sub
Private Sub cmdBackup_Click()
Dim Dbco As Database
Dim DbName As String DbName = App.Path & "\mdd.mdb"
Set Dbco = OpenDatabase(DbName, False, False, "") On Error GoTo errEnd
Dbco.Close
Set Dbco = Nothing If Dir(App.Path & "\mdd_bak.dat") <> "" Then
Kill App.Path & "\mdd_bak.dat"
DBEngine.CompactDatabase DbName, App.Path & "\mdd_bak.dat"
Else
DBEngine.CompactDatabase DbName, App.Path & "\mdd_bak.dat"
End if
Set Dbco = OpenDatabase(DbName, False, False, "")
Exit Sub
errEnd:
MsgBox Err.Description, vbCritical, "系统提示"
End Sub
Dim StrCnn As New ADODB.Connection
Dim itmX As ListItem
Dim dri As String
Private Sub Command1_Click()
NamStr = Dir1.Path & "\" & Trim(Text1.Text) & ".bak"
If Text1.Text <> "" Then
If Dir(NamStr) <> "" Then '判断文件是否已经有同名存在
MsgBox "数据库已经存在,请换其他名称!"
Else
StrCnn.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Data Source=wangguan"
SQL = "backup database cgroup to disk = '" & NamStr & "'" '备份数据库 StrCnn.Execute (SQL) '执行SQL语句
StrCnn.Close
MsgBox "数据库备份成功!", vbOKOnly + vbInformation, "提示"
End If
Else
MsgBox "请输入文件名", vbOKOnly + vbInformation, "提示"
End If
End SubPrivate Sub Command2_Click()
Unload Me
End SubPrivate Sub Dir1_Change()
Label1.Caption = Dir1.Path
End SubPrivate Sub Drive1_Change()
Dir1.Path = Drive1.Drive
End SubPrivate Sub Form_Load()
Label1.Caption = Dir1.Path
End Sub
很简单