compact .eap file

[vige46]

Hello,

I'd like to call 'compact .eap file' function from my script, but I can't find it.

Is this function supported in automation interface?

Thank you for help.

I use EA of version 3.6.659( Professional Edition)

Regards,
Miro

[thomaskilian]

Not quite shure, but this seems to be ACCESS basics. Maybe it can be found in the JET interface

[sargasso]

Take a look at www.databaseadvisors.com I am sure they would have someting on this topic (compressing Access dbs) somewhere.

bruce

[vige46]

Thanks for advices.

var Engine = new ActiveXObject("JRO.JetEngine");

Engine.CompactDatabase("Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+mdl,
   "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+mdlnew);


Note, that 'Use JET 4.0' in Local Options-General should be set.