Clive Beaton
asked on
How do I compact and repair a database with a password
I'm trying to compact and repair a password protected database with the following code:
Public Sub Compact()
Dim CurrentFile As String, BackupFile As String
On Error GoTo 0
CurrentFile = "C:\CAV3\Database1.accdb"
BackupFile = "F:\Database1.accdb"
If Dir(BackupFile) > "" Then
Kill BackupFile
End If
Application.CompactRepair CurrentFile, BackupFile, True
Exit Sub
End Sub
How do I change it to supply the password?
Thanks in advance.
Public Sub Compact()
Dim CurrentFile As String, BackupFile As String
On Error GoTo 0
CurrentFile = "C:\CAV3\Database1.accdb"
BackupFile = "F:\Database1.accdb"
If Dir(BackupFile) > "" Then
Kill BackupFile
End If
Application.CompactRepair CurrentFile, BackupFile, True
Exit Sub
End Sub
How do I change it to supply the password?
Thanks in advance.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER