Private Sub Form_Load()
Text1.Text = App.Path & "\db1.mdb"
Text1.Text = App.Path & "\db1.mdb"
End Sub
Private Sub Command1_Click()
'On Error Resume Next
'Dim sNewName As String
'Dim sBakFile As String
'sNewName = Text1.Text
'sdatabase = sNewName
'brepairMDB = False
'MousePointer = 11
'sBakFile = Left$(sdatabase, Len(sdatabase) - 4) & Date & ".mdb"
'If Check1.Value = 1 Then
' FileCopy sdatabase, sBakFile '备份数据库
'End If
'DBEngine.RepairDatabase sdatabase '修复数据库
'MousePointer = 0
'MsgBox "已完成数据库的修复工作!"
On Error Resume Next
Dim sNewName As String
Dim sBakFile As String
sNewName = Text1.Text
sdatabase = sNewName
brepairMDB = fasle
MousePointer = 11
'sBakFile = Left$(sdatabase, Len(sdatabase) - 4) & Data & ".mdb"
sBakFile = Left$(sdatabase, Len(sdatabase) - 4) & Date & ".mdb"
'sBakFile = Left$(sdatabase, Len(sdatabase) - 4) & Data & ".mdb"
MsgBox "已经备份了"
If Check1.Value = 1 Then
FileCopy sdatabase, sBakFile
End If
DBEngine.RepairDatabase sdatabase
MousePointer = 0
MsgBox "已经完成数据库的修复工作"
End Sub
Private Sub Command2_Click()
End
End Sub————————————————————————————————————————————
'sBakFile = Left$(sdatabase, Len(sdatabase) - 4) & Data & ".mdb"
sBakFile = Left$(sdatabase, Len(sdatabase) - 4) & Date & ".mdb"
'sBakFile = Left$(sdatabase, Len(sdatabase) - 4) & Data & ".mdb"
为什么只有第2行可以备份?
Text1.Text = App.Path & "\db1.mdb"
Text1.Text = App.Path & "\db1.mdb"
End Sub
Private Sub Command1_Click()
'On Error Resume Next
'Dim sNewName As String
'Dim sBakFile As String
'sNewName = Text1.Text
'sdatabase = sNewName
'brepairMDB = False
'MousePointer = 11
'sBakFile = Left$(sdatabase, Len(sdatabase) - 4) & Date & ".mdb"
'If Check1.Value = 1 Then
' FileCopy sdatabase, sBakFile '备份数据库
'End If
'DBEngine.RepairDatabase sdatabase '修复数据库
'MousePointer = 0
'MsgBox "已完成数据库的修复工作!"
On Error Resume Next
Dim sNewName As String
Dim sBakFile As String
sNewName = Text1.Text
sdatabase = sNewName
brepairMDB = fasle
MousePointer = 11
'sBakFile = Left$(sdatabase, Len(sdatabase) - 4) & Data & ".mdb"
sBakFile = Left$(sdatabase, Len(sdatabase) - 4) & Date & ".mdb"
'sBakFile = Left$(sdatabase, Len(sdatabase) - 4) & Data & ".mdb"
MsgBox "已经备份了"
If Check1.Value = 1 Then
FileCopy sdatabase, sBakFile
End If
DBEngine.RepairDatabase sdatabase
MousePointer = 0
MsgBox "已经完成数据库的修复工作"
End Sub
Private Sub Command2_Click()
End
End Sub————————————————————————————————————————————
'sBakFile = Left$(sdatabase, Len(sdatabase) - 4) & Data & ".mdb"
sBakFile = Left$(sdatabase, Len(sdatabase) - 4) & Date & ".mdb"
'sBakFile = Left$(sdatabase, Len(sdatabase) - 4) & Data & ".mdb"
为什么只有第2行可以备份?
解决方案 »
- ADooB.Comnand.ActiveConnection.BeginTrans:变量s=TRUE
- 求教一条SQL语句!!!
- 错误问题: 错误的文件名或数!但是手动就可以运行
- vb连接ORACLE
- 急!!!水晶报表的问题,各位大虾救我!!!
- 如何把DBF的某个字段的第一个记录的值赋予一个变量呀?
- VB里面能够通过me.name得到form的名字,那有没有类似的办法得到函数或者过程的名字
- 对Timer控件的检测时间问题(高手请进)
- 各位大仙,如何在PictureBox中绘制Line控件,怎样才能捕捉到Line控件之间的端点是否相交??急!!
- 关于对象拷贝的问题
- 怎样实现菜单内容的动态改变?高手帮忙
- 关于活动窗口的问题!
Data & ".mdb" ---aDate & ".mdb"----e
另外需要格式化一下内容,否则会有特殊字符不允许用在文件名称
sBakFile = Left$(sdatabase, Len(sdatabase) - 4) & Format(Date,"YYYYMMDD") & ".mdb"