RepairDatabase

[egapogi]

Anybody who has an idea why RepairDatabase is no longer supported in DAO 3.6?

It was supported in DAO 3.5.....

What is the equivalent method of RepairDatabase in DAO 3.6 by the way?

Thanks,
ega

 

[CCLINT]

Add the reference to the JDO (PROJECT|REFERENCES) "Microsoft Jet And Replication Objects Library 2.5"

Dim jro As jro.JetEngine
Set jro = New jro.JetEngine
jro.CompactDatabase "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\\nwind2.mdb", _
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\\abbc2.mdb;Jet OLEDB:Engine Type=4"

Check out this site in the MS kb:

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q230501

 

[egapogi]

thanks CCLINT,

but where should i place the user and password... the mdb hass userlevel security.

thanks again,
ega

 

[CCLINT]

myJRO.CompactDatabase "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\mymdb\\sample.mdb;Jet OLEDBatabase Password=YourPassword;", _
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\mymdb\\compactedSample.mdb;Jet OLEDB:Engine Type=5; Jet OLEDBatabase Password=YourPassword;"