Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionPublic Function CompressDatabase(ByVal Prm_strSourceDB As String, ByVal Prm_strPass As String) As Boolean Dim objJRO As Object Dim strDBDst As String Dim boolConnexionClose As Boolean On Error GoTo CompressDatabase_Err Screen.MousePointer = vbHourglass Set objJRO = CreateObject("JRO.JetEngine") strDBDst = Replace(Prm_strSourceDB, ".mdb", "_backup.mdb") If (FileExist(strDBDst)) Then Kill strDBDst ' Compactage / OLEEngine = 5 objJRO.CompactDatabase "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Prm_strSourceDB & ";Jet OLEDB:System Database=" & Replace(Prm_strSourceDB, "mdb", "mdw") & ";User ID=USER;Password=Pass"), _ "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strDBDst & ";Jet OLEDB:Encrypt Database=True;Jet OLEDB:Engine Type=5" If (FileExist(strDBDst)) Then Kill Prm_strSourceDB Name strDBDst As Prm_strSourceDB CompressDatabase = True End If CompressDatabase_Fin: Set objJRO = Nothing Screen.MousePointer = vbNormal Exit Function CompressDatabase_Err: Call MsgBox Err.Description Resume CompressDatabase_Fin End Function