Database Bloat

[Custardptt]

Hi all,

My application needs to load data from two xml documents, I’ve used the command:
Application.ImportXML stDocName, acStructureAndData
After the import is checked, the data is transferred to the main tables and the tables created by the XML import are deleted:
DoCmd.RunSQL "DROP TABLE [" stXMLTablename "]"
The database .mdb file increases in size by ~3MB when the XML is imported. This is not reclaimed when the tables are dropped.

How do I stop the Access from growing like this?

Thanks in advance

Peter Tyacke

 

[PHV]

Compact/Repair the database after the tables are dropped.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Custardptt]

PHV,

Thanks for your comment, in the past I've used the 'compact on close' but I've always felt that was a sticky tape and chewing gum effort to cover my rubbish programming.

I've spent loads of time today making sure everything's closed and set to nothing so I'm sulking a bit about my 30MB database with 200K's worth of data.

Is there no way of cleaning up the mess as I go?

Sorry to try your patience

Pete