Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004

    Arrow Unanswered: great increase in database size

    I have a db and when it is fully compacted it is only 9 to 10 mb in size. However, in a few days if I don't compact it, it can get to 80 to 90 mb's in size.
    What causes this great increase? How can it possible to compact from front end (VB)?
    Last edited by hemasekhar; 01-27-04 at 08:02.

  2. #2
    Join Date
    Sep 2002
    South Wales

    Lightbulb Try this link

    Have a look at Tony Toews site may give a few ideas
    Windows Server 2003-8 / Terminal Services / SQL 2000 / Access 2003 / Office 2003-7 / Exchange 2003-7 / Blackberry Enterprise Server / AutoCAD / Lambert And Butler / Red Bull

  3. #3
    Join Date
    Aug 2003
    It is impossible to compact a database from the same database. However, you can have a database that just compacts other databases. Then place some code in your original database to open the second one.

    Hope this doesn't sound too garbled!

    Sorry - i don't have the code to compact another database i just know that it can be done!


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts