🚀 go-pugleaf

On Thu, 14 Nov 2002 17:52:57 -0800, Mike C wrote:

>Not 100% sure here but you might try having a look at Compacting and
>Repairing your database.  Try it from within MS Access first, on the
>oversized table i .e. Open 'Big' Database, Tools->Database
>Utilities->Compact and Repair Database.

I'm not talking about the database size, but the table size inside the
database.  

I've since discovered that getting ADOX to work again created tables which
weren't double-sized.

>Don't really know why this should happen, but if performing a C&R operation
>resolved your problem then drop me an e-mail and I can send you a code
>snippet to perform this operation under C++Builder.

I know how to do that programatically, but we're doing it manually at the
same time the database password is being added, because the program allows
one to append data.  Compacting takes a long time (way too long - Access sits
there with little CPU usage and very little disk access, doing who knows
what), so we only want to do it once.

>By the way, are you creating your table from within Builder, via an ADO
>connection?  Is so, how?  I would like to see the code if possible.

The problematic tables are created via SQL, using a TADOCommand object.

Non-problematic tables can be created with ADOX (Catalog, Table, and Column
objects).


--
 - Mike

Remove 'spambegone.net' and reverse to send e-mail.