🚀 go-pugleaf

Hi everyone, having a small problem with an Access 97 / 2000 database.  I
need to impliment the compact & repair function that is avaliable within the
Acces IDE.

The problem is that my database is getting incresingly large, I think this
is because Access doesn't dellete records, it mearly flags them as being
deleted untill the database is compacted.  This is also true for AutoNumber
keys, which should be re-ordered so that they start from 0 or 1 etc.

I've seen a few messages posted about compacting Access databases, but
knowone seems to have been able to achieve this with in Builder.  I've also
been to the MS web-site and tried to impliment there code example into
Builder, but with know joy.  The code I was using was:

#import "...\Common Files\System\ado\msjro.dll" no_namespace
#import "...\Common Files\System\ado\msado15.dll" no_namespace

try
{
    IJetEnginePtr jet(__uuidof(JetEngine));
    jet->CompactDatabase( required params etc);
}
catch(_com_error &e)
{
    ShowMessage("Error");
}

- I get the message, "improper use of typedef", relating to the
IJetEnginePtr line.

I also thought that I might be able to execute the Compact & Repair command
throught a macro or VB module from within the access database, but again I
don't know if this is possible.

Sorry about the long message, any help would be much appreshialeted

Mike