Public Sub CompactJetDatabase(Location As String, Optional BackupOriginal As Boolean = True) On Error GoTo CompactErr Dim strBackupFile As String Dim strTempFile As String
Conn.Close '检查数据库文件是否存在 If Len(Dir(Location)) Then ' 如果需要备份就执行备份 If BackupOriginal = True Then strBackupFile = App.Path & "\backup.mdb" If Len(Dir(strBackupFile)) Then Kill strBackupFile FileCopy Location, strBackupFile End If ' 创建临时文件名 strTempFile = App.Path & "\temp.mdb" If Len(Dir(strTempFile)) Then Kill strTempFile '通过DBEngine 压缩数据库文件 DBEngine.CompactDatabase Location, strTempFile
' 删除原来的数据库文件 Kill Location ' 拷贝刚刚压缩过临时数据库文件至原来位置 FileCopy strTempFile, Location ' 删除临时文件 Kill strTempFile Else End If Conn.Open StrConn CompactErr: Exit Sub End Sub
Copy一下不就行了,还要什么备份啊?
to: henrryzhang(North Wolf) 请问如果数据库是带密码的怎么办,会报错“Not a Valid Password”请帮忙,谢谢
Public Sub CompactJetDatabase(Location As String, Optional BackupOriginal As Boolean = True)
On Error GoTo CompactErr
Dim strBackupFile As String
Dim strTempFile As String
Conn.Close
'检查数据库文件是否存在
If Len(Dir(Location)) Then ' 如果需要备份就执行备份
If BackupOriginal = True Then
strBackupFile = App.Path & "\backup.mdb"
If Len(Dir(strBackupFile)) Then Kill strBackupFile
FileCopy Location, strBackupFile
End If ' 创建临时文件名
strTempFile = App.Path & "\temp.mdb"
If Len(Dir(strTempFile)) Then Kill strTempFile
'通过DBEngine 压缩数据库文件
DBEngine.CompactDatabase Location, strTempFile
' 删除原来的数据库文件
Kill Location
' 拷贝刚刚压缩过临时数据库文件至原来位置
FileCopy strTempFile, Location
' 删除临时文件
Kill strTempFile
Else
End If
Conn.Open StrConn
CompactErr:
Exit Sub
End Sub
请问如果数据库是带密码的怎么办,会报错“Not a Valid Password”请帮忙,谢谢
tmpDataBase.NewPassword "Password", ""
DBEngine.CompactDataBase "原库名", "新库名", , , ";pwd=密码"ADO:
JRO.CompactDatabase "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strSource & ";Jet OLEDB:Database Password=" & strPassword, _
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strDestDB & ";Jet OLEDB:Database Password=" & strPassword