Can we "Compact and Repair..." mdb file programatically?

[rajeshkhanna_in]

Hi all,
Is it possible to programatically "Compact and Repair" an mdb file as can be done manually from MSACCESS menu "Tools"-> "Database Utilities" -> "Compact and Repair Database..."
Any help will be appreciated...

Rajesh Khanna

[debasisdas]

please find a related discussion here.

[JA12]

Hi all,
Is it possible to programatically "Compact and Repair" an mdb file as can be done manually from MSACCESS menu "Tools"-> "Database Utilities" -> "Compact and Repair Database..."
Any help will be appreciated...

Rajesh Khanna

Apparently, Yes.

http://office.microsoft.com/en-gb/access/HA010345701033.aspx?pid=CL100570041033

"Run Microsoft Visual Basic® for Applications (VBA) code that uses the CompactDatabase method of either Microsoft Jet and Replication Objects (JRO) or Microsoft Data Access Objects (DAO)."

'Compact the database
    DB_sour = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" _
        & strSourcePath & ";" & "Jet OLEDB:Database Password=" & strPassword
& ";"

    DB_dest = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" _
            & strTempFile & " ;Jet OLEDB:Engine Type=5;" & _
            "Jet OLEDB:Database Password=" & strPassword & ";"

    JROje.CompactDatabase DB_sour, DB_dest