🚀 go-pugleaf

Vassiliev
Thanks for the tips - I have to ask the PATH you refer to, could you please
be more specific.  I know of the Directories/Conditionals under Options
under Projects - Is that the one you refer to?

BTW - I did as you suggested but I have a problem with a Linker error -
indicating that Public symbol 'Jro_tlb::IID_IJetEngine' defined in both
module F:\...\MAIN.OBJ and F:\...\DMVSTORE.OBJ Note: it does this for about
7 Public Symbols...

I have made my DataModule a Friend class of my Main Unit so it can use its
private methods, this could be the reason also both Units have each of the
others included in their respective header files - I have to admit that I
have never had any problems with the Linker so my knowledge is very, very
limited.  Any more hints, even a pointer in the right direction would be
good.

Thanks
Daryl


"Vassiliev V.V." <news@vassilievvv.mtu-net.ru> wrote in message
news:3dea0d97@newsgroups.borland.com...
> Include Jro_tlb.cpp into your project (you can get it by importing Jet
type
> library).
>
> You can also use
>
> #include <ComObj.hpp>
>
>  try
>  {
>    HRESULT hr = JetEngine->CompactDatabase(Source.c_bstr(),
Dest.c_bstr());
>    OleCheck(hr);
>  }
>  __finally
>  {
>    JetEngine->Release();
>  }
>
> instead of
>
>  JetEngine->CompactDatabase(Source.c_bstr(), Dest.c_bstr());
>  JetEngine->Release();
>
> if you need to check an error
>
> About BCB5 and BCB6 on the same machine - exclude all links to BCB\Imports
> and BCB\Lib and BCB\Project (generally BCB\*) from your PATH. They can
> coexist.
>
> ----------------------------------------------------------------
> Regards,
> Viatcheslav V. Vassiliev
> http://www.oledbdirect.com
> The fastest way to access MS SQL Server and MS Jet (MS Access) databases.
>
>
> "Daryl" <stockd@cqnet.com.au> �������/�������� � �������� ���������:
> news:3de92627@newsgroups.borland.com...
> > Hi
> > I logged on last night to ask the same question, could not believe my
luck
> > when I saw this post.  I attempted to compile my application after
adding
> > the example code and I received the following linker errors.
> >
> > [Linker Error] Unresolved external 'Jro_tlb::ID_IJetEngine 'referenced
> from
> > F:\MY DOCUMENTS\ACCESS2000\VIDEOSTORE\MAIN.OBJ
> >
> > and
> >
> > [Linker Error] Unresolved external 'Jro_tlb::CLSID_JetEngine 'referenced
> > from F:\MY DOCUMENTS\ACCESS2000\VIDEOSTORE\MAIN.OBJ
> >
> > I have included JRO_TLB.H in the header file,  the other variables in
the
> > function CoCreateInstance can be found/viewed by highlighting using the
> CTRL
> > key and selecting it.  I have run out of ideas so any help would be very
> > good...
> >
> > Actually, I have been having quite a few problems with linker errors
since
> I
> > have installed BB6 pro, I have left BB5 pro installed - I am now
starting
> to
> > wonder if BB6 upgrade was a good move, especially as all my applications
> > have had difficulty with the new environment.
> >
> > Features that use automation (EXCEL APP) have had to have major work to
> get
> > them to compile, I am still having problems with EXCEL.EXE hanging
around
> in
> > memory (which causes problems to other apps using it).  I had this all
> > sorted out with BB5 but for some reason the same techniques do not work
> with
> > BB6.
> >
> > You can also see other recent posts about Linker errors when trying to
set
> > ADO dataset properties, these also worked well in BB5, now will not link
> in
> > BB6.  The solution may be to remove BB5 and BB6 and reinstall only BB6,
I
> > have been steering away from that due to having to get another
activation
> > key.
> >
> >
> > Daryl
> >
> > "Vassiliev V.V." <news@vassilievvv.mtu-net.ru> wrote in message
> > news:3de87c27@newsgroups.borland.com...
> > > 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);
> > >
> > >  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,
> > > Vassiliev V.V.
> > > http://www.oledbdirect.com
> > >
> > > "adward" <adward_lee@seed.net.tw> �������/�������� � ��������
���������:
> > > news:3de8421d@newsgroups.borland.com...
> > > > Hi,
> > > >
> > > > does anyone kown how to compress Access Database in C++ Builder 6.0?
> > > >
> > > > Thanks!!
> > > >
> > > >
> > >
> > >
> >
> >
>
>