Web Wiz Support and Community Forums : Error when trying to compact https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 06 Apr 2026 12:14:53 +0000 Tue, 25 Nov 2003 16:18:03 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=7574 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Error when trying to compact : For this feature to work yes. How...]]> https://forums.webwiz.net/error-when-trying-to-compact_topic7574_post38033.html#38033 Author: WebWiz-Bruce
Subject: 7574
Posted: 25 November 2003 at 4:18pm

For this feature to work yes.

How it works is:-
  1. Makes a backup using FSO object.
  2. Compacts and repairs the database to wwForum-tmp.mdb using the JET database engine.
  3. Deletes the old uncompacted database using the FSO object.
  4. Renames the wwForum-tmp.mdb to the orignal name of the database using the FSO object.


Edited by -boRg-]]> Tue, 25 Nov 2003 16:18:03 +0000 https://forums.webwiz.net/error-when-trying-to-compact_topic7574_post38033.html#38033 <![CDATA[Error when trying to compact : Would this mean that the IUSR...]]> https://forums.webwiz.net/error-when-trying-to-compact_topic7574_post38019.html#38019 Author: Joey805
Subject: 7574
Posted: 25 November 2003 at 2:34pm

Would  this mean  that the IUSR account would need delete rights to the database folder? Or is there a more secure way of doing this?

Thanks Again,

Joey

]]> Tue, 25 Nov 2003 14:34:29 +0000 https://forums.webwiz.net/error-when-trying-to-compact_topic7574_post38019.html#38019 <![CDATA[Error when trying to compact : Then I&#039;m afraid unless...]]> https://forums.webwiz.net/error-when-trying-to-compact_topic7574_post37985.html#37985 Author: WebWiz-Bruce
Subject: 7574
Posted: 25 November 2003 at 11:48am

Then I'm afraid unless you can get the permissions changed on the forumto delete files as well you don't have any choice but use the databaseuncompacted.

According to your previous post the compact procedure has already taken place so the file:-

wwForum-tmp.mdb

Will already be compacted, so use this file instead by renaming it on the server to wwForum.mdb


Edited by -boRg-]]> Tue, 25 Nov 2003 11:48:06 +0000 https://forums.webwiz.net/error-when-trying-to-compact_topic7574_post37985.html#37985 <![CDATA[Error when trying to compact : The only thing I can do when I...]]> https://forums.webwiz.net/error-when-trying-to-compact_topic7574_post37975.html#37975 Author: Joey805
Subject: 7574
Posted: 25 November 2003 at 10:56am

The only thing I can do when I download the file manually is to repair it in access, I cannot compact it. It says im using a newer version of access than what the file is using. ]]> Tue, 25 Nov 2003 10:56:20 +0000 https://forums.webwiz.net/error-when-trying-to-compact_topic7574_post37975.html#37975 <![CDATA[Error when trying to compact : You need to have permisison to...]]> https://forums.webwiz.net/error-when-trying-to-compact_topic7574_post37941.html#37941 Author: WebWiz-Bruce
Subject: 7574
Posted: 25 November 2003 at 8:54am

You need to have permisison to delete files on the server.

If you don't go back to the backup database and rename it using FTP. Ifyou wish to comapct and repair the database you may need to do thismanually by downloading the database via FTP, open in access, compactand repair the database from accesses tools menu, and then reupload thedatabase again.
]]> Tue, 25 Nov 2003 08:54:14 +0000 https://forums.webwiz.net/error-when-trying-to-compact_topic7574_post37941.html#37941 <![CDATA[Error when trying to compact : When I select to compact my access...]]> https://forums.webwiz.net/error-when-trying-to-compact_topic7574_post37865.html#37865 Author: Joey805
Subject: 7574
Posted: 24 November 2003 at 5:21pm

When I select to compact my access 2000 database in my web wiz forum admin, I get the following error message:

  1. Database backed up to:-
    D:\inetpub\wwwroot\socalsinker.com\forum\admin\database\wwFo rum-backup.mdb

  2. New compacted database:-
    D:\inetpub\wwwroot\socalsinker.com\forum\admin\database\wwFo rum-tmp.mdb

    Microsoft VBScript runtime error '800a0046'

    Permission denied

    /forum/admin/compact_access_db.asp, line 136

Does anyone know how to fix this?]]> Mon, 24 Nov 2003 17:21:15 +0000 https://forums.webwiz.net/error-when-trying-to-compact_topic7574_post37865.html#37865