Web Wiz Forums - Compact and Repair Access Database

Print Page | Close Window

Compact and Repair Access Database

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=31471
Printed Date: 29 March 2026 at 1:29pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Compact and Repair Access Database

Posted By: Bo3Dyx
Subject: Compact and Repair Access Database
Date Posted: 20 April 2017 at 10:53am

Does not work Compact and Repair Access Database.

I tried on different hostings.

HTTP Error 404.0 - Not Found

The resource you are looking for has been removed, had its name changed, or is temporarily unavailable.

Most likely causes:

The directory or file specified does not exist on the Web server.
The URL contains a typographical error.
A custom filter or module, such as URLScan, restricts access to the file.

Things you can try:

Create the content on the Web server.
Review the browser URL.
Create a tracing rule to track failed requests for this HTTP status code and see which module is calling SetStatus. For more information about creating a tracing rule for failed requests, click http://go.microsoft.com/fwlink/?LinkID=66439" rel="nofollow - here .

Detailed Error Information:

Module	IIS Web Core
Notification	MapRequestHandler
Handler	StaticFile
Error Code	0x80070002

Requested URL	http://*****.com:80/admin_compact_access_db.aspcd
Physical Path	h:\root\home\bo3dyx-001\www\site1\admin_compact_access_db.aspcd

Replies:

Posted By: WebWiz-Bruce
Date Posted: 20 April 2017 at 1:59pm

This tool will only work with older .mdb Access databases on systems supporting the JET database driver.

The URL you have gives the page name as 'admin_compact_access_db.aspcd' when it should be 'admin_compact_access_db.asp'. As the file 'admin_compact_access_db.aspcd' is not the name of the file it would cause a 404 error.

We have tested this in the lab and cannot find where the page name 'admin_compact_access_db.aspcd' is coming from unless something on the server you are using is changing the page name, possibly some form of fitering?

-------------
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: Bo3Dyx
Date Posted: 20 April 2017 at 4:22pm

On another hosting, here is the error message:

wrote:

From here you can Compact and Repair the Access database used for the Forum making the database size smaller and the forum perform faster.This feature can also repair a damaged or corrupted database.

Database backed up to:-
d:\hst\svvaul-com_cd0cbf59\http\forum\BD\Forum-backup.mdb

If you are the system administrator please click http://go.microsoft.com/fwlink/?LinkID=82731" rel="nofollow - here to find out more about this error.

And yes, I know that there are no files with * .aspcd extension

Posted By: Bo3Dyx
Date Posted: 21 April 2017 at 6:40am

Installed version 10.18 - everything is working fine, the database is being repaired and compressed ....

Posted By: WebWiz-Bruce
Date Posted: 21 April 2017 at 7:23am

The latest version is 11.10, I would advise upgrading to the latest release.

SQL Server is the recommend database type with Web Wiz Forums.

Microsoft do provide the SQL Server Migration Assistant for Access that can migrate an Access database to SQL Server. The tool does add in some constraints to tables that need to be removed, but apart from this it works very well.

-------------
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: Bo3Dyx
Date Posted: 21 April 2017 at 7:50am

Version 11.10 is absolutely not usable. For a week my base of MDB has grown from 10 MB to 30 MB without new messages! Everything began to work very slowly, and I could not squeeze the base, as I wrote above, but you do not believe me. I installed 11.10 on the test hosting but also there was the same error when compressing the database.

Have a nice day.

Posted By: WebWiz-Bruce
Date Posted: 21 April 2017 at 2:42pm

The Compact and Repair Access Tool was written some 10 years ago. It therefore could probably do with some work being spent on it to see if it could be improved.

Access is a flat file database so is only intended for tiny forums with a handful of members, a couple of hundred posts, and a small amount of daily traffic. Any more than this you should look at using SQL Server.

It could be that the forum is receiving allot of traffic and string the sessions within the database. With Access when the data is deleted the database does not shrink in size until it is compacted and repaired. If you are using Access you should disable the option to store the forum session in the database to prevent the database being overally large and/or becoming corrupted as Access would be unable to cope with the high level of activity caused by session data being stored within the database.

Our primary business is web hosting and we operate our own network and servers which Web Wiz Forums works well on without any errors. All our hosting packages also come with SQL Server databases so you do not need to use Access. We can even help migrate your present Web Wiz Forums Access database to SQL Server. You can view the hosting packages that we provide at the page below;

http://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - https://www.webwiz.net/web-hosting/windows-web-hosting.htm

-------------
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: WebWiz-Bruce
Date Posted: 21 April 2017 at 3:24pm

I have been doing lots of testing in the lab here and the Compact and Repair Tool appears to work fine.

You do though need to select the 'Microsoft JET Access Driver' when installing/upgrading to version 11.10 as the 'Microsoft ACE Access Driver' is not supported by the Compact and Repair Tool.

I suspect that your issue was that you select the default option for using the 'Microsoft ACE Access Driver' when installing Web Wiz Forums version 11.10 which is why the Compact and Repair Tool failed to run.

Additional error handling will be added to the next release disable the Compact and Repair Tool if the 'Microsoft ACE Access Driver' is selected for Web Wiz Forums.

-------------
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: jamm_brat
Date Posted: 14 October 2017 at 11:48am

Bo3Dyx wrote:

Does not work Compact and Repair Access Database.

Some useful information has been shared here - http://wordpress.semnaitik.com/2013/07/17/repair-access-database-manually/

Posted By: edwards142
Date Posted: 31 January 2018 at 5:03am

Sometime the situation may occur that Compact And Repair in built-utility tool of Access Database starts working differently or stopped working. If anyone facing this issue then you must try the manual fixes to resolve this. you can check out the manual fixes complete listing to resolve such.

http://www.accessrepairnrecovery.com/blog/repair-mdb-s-compact-repair-not-work

Posted By: Bo3Dyx
Date Posted: 12 March 2018 at 5:24am

Thanks, for the tips.