Web Wiz Support and Community Forums : Database size stays the same ..... https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 11 Apr 2026 22:51:33 +0000 Mon, 03 Jan 2005 05:48:20 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=13185 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Database size stays the same ..... : For whatever reason MS have done...]]> https://forums.webwiz.net/database-size-stays-the-same_topic13185_post72963.html#72963 Author: WebWiz-Bruce
Subject: 13185
Posted: 03 January 2005 at 5:48am

For whatever reason MS have done it, when you delete data from anaccess database it doesn't actually delete the data so the databasesize remains the same.

Once you delete data from an access database to get the size to decrease you need to compact and repair the database.
]]> Mon, 03 Jan 2005 05:48:20 +0000 https://forums.webwiz.net/database-size-stays-the-same_topic13185_post72963.html#72963 <![CDATA[Database size stays the same ..... : I batch deleted topics that have...]]> https://forums.webwiz.net/database-size-stays-the-same_topic13185_post72957.html#72957 Author: greytricky
Subject: 13185
Posted: 03 January 2005 at 4:13am

I batch deleted topics that have not been posted in for a whole year (good housekeeping) and expected the forum database size to drop down from its current 150 meg to significantly less

The forum database is still the same size, doesn't the forum 'actually delete' these files or does it move them to a safe/unused part of the database ??
Is there a safe, quick way of reducing the db size when batch deleting?
 
p.s. thanks for all the support in 2004, its been great!
]]> Mon, 03 Jan 2005 04:13:04 +0000 https://forums.webwiz.net/database-size-stays-the-same_topic13185_post72957.html#72957