🚀 go-pugleaf

  
   Thanks for the solution,

But how can compact the database without creating the copied one (Compacted.mdb)?
can it done by just changing the name of Compacted.mdb to test.mdb?

>Why it crashes? It's not the normal behavior...
Sometimes my databases crashed which leads that my app does not work properly (with the items related to de db).





"Vladimir Stefanovic" <antivari@po.sbb.co.yu> wrote:
>This is not an API question. It's a question for ADO
>group, and it has been answered many times:
>
><quote>
>
>When compacting Access db it must be disconnected.
>
>Import "Microsoft Jet and Replication Objects 2.x Library".
>
>#include <JRO_TLB.h>
>...
>void __fastcall TForm1::Button1Click(TObject *Sender)
>{
> IJetEngine * JetEngine = NULL;
> CoCreateInstance(CLSID_JetEngine, NULL, CLSCTX_INPROC_SERVER,
>  IID_IJetEngine, (void**) &JetEngine);
> try
> {
>  WideString Source = "Provider=Microsoft.Jet.OLEDB.4.0;"
>   "Data Source=C:\\Test\\Test.mdb;";
>  WideString Dest = "Provider=Microsoft.Jet.OLEDB.4.0;"
>   "Data Source=C:\\Test\\Compacted.mdb;";
>
>  JetEngine->CompactDatabase(Source.c_bstr(), Dest.c_bstr());
> }
>__finally
> {
>  JetEngine->Release();
> }
>}
>
>Compact will also repair database.
>
></quote>
>
>
>> I am having a trouble with a MS Access2000 database.
>> I have to compact and repair it everytime my app crashes.
>
>Why it crashes? It's not the normal behavior...
>
>
>-- 
>Best regards,
>Vladimir Stefanovic 
>
>