🚀 go-pugleaf

Hi all,

I can't find a better newsgroup to ask this question in. I'm trying to use
TAccessApplication with Builder 5 to open a paradox table (TTable) and then
export it to MS Excel format. This is my first time doing servers and I'm
well lost. All MS documentation is in VisualBasic which doesn't help much.
So far this is what I have...

//try to connect to access
   AccessApplication1->Connect();
   AnsiString Name("C:\\atest\\db1.mdb");
   wchar_t* NameWide=new wchar_t[Name.WideCharBufSize()+1];
   Name.WideChar(&NameWide[0],Name.WideCharBufSize());
   AccessApplication1->OpenCurrentDatabase(NameWide,false);
   DatabasePtr dbs=AccessApplication1->CurrentDb();
   AccessApplication1->DoCmd->OpenTable("db1",acViewNormal,acReadOnly);
   AccessApplication1->CloseCurrentDatabase();
   delete[] NameWide;
   AccessApplication1->Disconnect();

Is MSAccess supposed to launch? or am I running commands that are backround
operated? Does anyone have a code snippet they could please share. I haven't
found any examples of using Access for this kind of thing. I'm interested in
how to retrieve any errors that these functions might be causing but I don't
see a usable error property.

Thanks,

John M. Borchers
SHI-APD Cryogenics
www.apdcryogenics.com