FiveTech Software tech support forums • How to "compact" an Access Database

Page 1 of 1

How to "compact" an Access Database

Posted: Sat Dec 22, 2007 4:19 pm

by hterce

Hi,

How do you "compact" an .MDB file in FW? Can somebody share me a code?

Thanks
Bert

Re: How to "compact" an Access Database

Posted: Sat Dec 22, 2007 7:19 pm

by Enrico Maria Giordano

Code: Select all

FUNCTION MAIN()

    LOCAL oJro := CREATEOBJECT( "JRO.JetEngine" )

    LOCAL cConStr1 := "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=old.mdb"
    LOCAL cConStr2 := "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=new.mdb"

    oJro:CompactDatabase( cConStr1, cConStr2 )

    RETURN NIL

EMG