Private Sub Command1_Click()
CommonDialog1.ShowOpen
Text1.Text = CommonDialog1.FileName
End SubPrivate Sub Command2_Click()
BackupDatabase
End SubPublic Sub BackupDatabase()
Dim s_path, s_dataexport As String
's_path = App.Path
Me.MousePointer = 11 '设置鼠标指针形状s_dataexport = "backup database zc to disk='" & CommonDialog1.FileName & "'"
If CommonDialog1.FileName <> "" Then
Conn.BeginTrans
Conn.Execute s_dataexport
Err.Number = 0
If Err.Number = 0 Then
Conn.CommitTrans
MsgBox "数据备份成功!", vbInformation, "提示"
MsgBox "数据备份文件存放路径:" & CommonDialog1.FileName, vbOKOnly, "提示"
Unload Me
Else
Conn.RollbackTrans
MsgBox "数据备份失败!请检查数据库是否正在打开!", vbCritical, "提示"
End If
'Conn.Close
'Set cn = Nothing
Me.MousePointer = 1
Else
MsgBox "请选择备份路径!"
Me.MousePointer = 1
End If
End Sub这是我的备份代码,运行的时候提示了“数据备份成功”,但是在文件夹下却没有备份的时候保存的那个文件。这是怎么回事儿?
CommonDialog1.ShowOpen
Text1.Text = CommonDialog1.FileName
End SubPrivate Sub Command2_Click()
BackupDatabase
End SubPublic Sub BackupDatabase()
Dim s_path, s_dataexport As String
's_path = App.Path
Me.MousePointer = 11 '设置鼠标指针形状s_dataexport = "backup database zc to disk='" & CommonDialog1.FileName & "'"
If CommonDialog1.FileName <> "" Then
Conn.BeginTrans
Conn.Execute s_dataexport
Err.Number = 0
If Err.Number = 0 Then
Conn.CommitTrans
MsgBox "数据备份成功!", vbInformation, "提示"
MsgBox "数据备份文件存放路径:" & CommonDialog1.FileName, vbOKOnly, "提示"
Unload Me
Else
Conn.RollbackTrans
MsgBox "数据备份失败!请检查数据库是否正在打开!", vbCritical, "提示"
End If
'Conn.Close
'Set cn = Nothing
Me.MousePointer = 1
Else
MsgBox "请选择备份路径!"
Me.MousePointer = 1
End If
End Sub这是我的备份代码,运行的时候提示了“数据备份成功”,但是在文件夹下却没有备份的时候保存的那个文件。这是怎么回事儿?
解决方案 »
- 注册表部分信息不能保存?
- ACCESS 数字型字段0.5显示为.5如何解决?
- 计时钟该怎么用??
- MSHFlexGrid 控件问题????
- 求用vb将excel表中的数据导入到sql中,并在MSHFlexGrid 控件上显示出来
- 如何使用VBA登录网页或者读取已打开登录好的网页
- 请教matlab高手,给退化的图像恢复处理
- 怎样loadpicture很大的图片文件,因为我使用这个函数时,会出现内存溢出
- 有没有办法让mmcontrol的输出窗口的maxbutton变为有效!
- 怎样使写的软件是要用户注册的,用什么方法区分试用或已注册的?
- VB中如何控制菜单!!
- 请问VB如何实现在MDI窗体上左边的导航栏?有什么控件或者是API没有?
Err.Number = 0
改成
Err.Number = 0
Conn.Execute s_dataexport