Delete problem in Access 2000 v6
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=1727
Printed Date: 30 March 2026 at 4:44pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Delete problem in Access 2000 v6
Posted By: loz321
Subject: Delete problem in Access 2000 v6
Date Posted: 09 April 2003 at 9:25pm
|
How do i delete threads? therough the admin side i deleted all the topics but the threads remain in the DB (30,000 posts - 100 topics - those topics only have on average 2-5 replies in them?) Also checked the DB...they are still there even though the topic was deleted? it's a busy site (2000-6000 page hits an hour - not just the forum) and my site was running on a 78 meg Access file... it's down to a 48 meg file, but that should probably be around 25.... yeah i know sql would be ideal but it's not available at this time. |
Replies:
Posted By: loz321
Date Posted: 09 April 2003 at 9:47pm
|
btw: the site is nissansilvia.com (or nissansilvia.com/forum for the forum) |
Posted By: Badaboem
Date Posted: 10 April 2003 at 10:20am
|
did you do a compact and repair? ------------- http://www.c4dportal.com"> 
|
Posted By: WebWiz-Bruce
Date Posted: 10 April 2003 at 1:45pm
|
The access database is a relational database so unless you have changed the database structure it would be impossible to delete the topic subjects without first deleting the the threads, if you tried you would get an error returned by 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 |
Posted By: loz321
Date Posted: 10 April 2003 at 5:32pm
| this is using the "topic delete" feature in the site. |
Posted By: loz321
Date Posted: 10 April 2003 at 5:34pm
|
then i downloaded the DB, and ran compact and repair through access and re-uploaded.. please look at : http://www.nissansilvia.com/forums - http://www.nissansilvia.com/forums to get an idea of what i mean have a look at "brags & stories" cheers.
|