Hi,
How do you "compact" an .MDB file in FW? Can somebody share me a code?
Thanks
Bert
How to "compact" an Access Database
- Enrico Maria Giordano
- Posts: 7355
- Joined: Thu Oct 06, 2005 8:17 pm
- Location: Roma - Italia
- Contact:
Re: How to "compact" an Access Database
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