Web Wiz Forums - Database size stays the same .....

Print Page | Close Window

Database size stays the same .....

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=13185
Printed Date: 12 April 2026 at 12:12am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Database size stays the same .....

Posted By: greytricky
Subject: Database size stays the same .....
Date 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!

Replies:

Posted By: WebWiz-Bruce
Date Posted: 03 January 2005 at 5:48am

For whatever reason MS have done it, when you delete data from an access database it doesn't actually delete the data so the database size 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.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting