🚀 go-pugleaf

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 I can't change
connection parms!). So If I want to disconnect there is something more
to do than ADODict->Close() to do, but what?????


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