🚀 go-pugleaf

CompactDatabase returns COM error code. 0 is S_OK - look winerror.h for more
codes, use OleCheck(errorCode) to throw exception in case error code
indicates error. JetEngine->Release() is the same as IUnknown->Release() -
look any help for COM for details.

You can find help on CoCreateInstance, IUnknown and other COM specifics in
MSDN.

----------------------------------------------------------------
Regards,
Viatcheslav V. Vassiliev
http://www.oledbdirect.com
The fastest way to access MS SQL Server, MS Jet (MS Access)
and Interbase (through OLEDB) databases.

"Joe Greenthal" <joegreenthal@cox.net> ???????/???????? ? ????????
?????????: news:3E5EE173.3040207@cox.net...
> 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
> >>
> >>
> >
> >
> >
>