🚀 go-pugleaf

Vassiliev:

I've been hunting for weeks on the Internet for a Borland example
of compacting an MSACCESS database. The information that I found
referred to MS VC++ or Delphi, none of these examples clued me in on
using the "CoCreateInstance(...)" method. Thank you for your example
that I found on Borland's ADO User's Group.

Do you have a list of error codes returned be "CompactDatabase(..)"
or "JetEngine->Release()" ?? I've determined that "0" is returned
by "CompactDatabase(..)" when the database has been compacted
successfully.


thanks,

Joe G.


Vassiliev V.V. wrote:
> Import type library:
> 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);
> 
>  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());
> 
>  JetEngine->Release();
> }
> 
> 
> You can compact database from one file into another. There should be no
> users connected to database.
> 
> ----------------------------------------------------------------
> Regards,
> Viatcheslav V. Vassiliev
> http://www.oledbdirect.com
> The fastest way to access MS SQL Server, MS Jet (MS Access)
> and Interbase (LCPI provider, http://ibp.lcpi.lipetsk.ru) databases.
> 
> "Gabriel Martinez" <gabotz@fibertel.com.ar> �������/�������� � ��������
> ���������: news:3e43c5f7@newsgroups.borland.com...
> 
>>is there a way to compact an access database from c++ builder. some code
> 
> may
> 
>>help, thanks
>>
>>
> 
> 
>