ldb file not deleted

From: Alain Bourgeois (bk332951_at_skynet.be)
Date: 02/29/04 

Date: Sun, 29 Feb 2004 13:20:37 +0100

Dear all,

I have a c++ builder 6 (v enterprise) application, using ADO to access a
MS-Access 2000 database.

The application works correctly (read, updates, ...), the problem I have
is that I have to close the mdb file to open another one with the same
TADOConnection ... and it doesn't work!

I close all open TADOQuery's, the TADOConnection is named ADODict:

// after closing queries
if (ADODict->InTransaction)
        ADODict->CommitTrans();
for (int i = 0; i < ADODict->DataSetCount; i++)
        if (ADODict->DataSets[i]->Active)
                ShowMessage(ADODict->DataSets[i]->Name);
// no active datasets were found
  ADODict->Close();
// LDB file is still there, adodict is still connected!!!!!

If I close the program the LDB file is deleted. So there is something
more to do than ADODict->Close(), but what?????

Any help welcome,
Alain Bourgeois
bk332951@skynet.be (pls put this e-mail in cc of your reply)
www.self-mail.com