Web Wiz

  New Posts New Posts RSS Feed - Compact and Repair Access Database
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Compact and Repair Access Database

 Post Reply Post Reply Page  12>
Author
Bo3Dyx View Drop Down
Groupie
Groupie
Avatar

Joined: 15 July 2008
Location: Russia, Saratov
Status: Offline
Points: 41
Post Options Post Options   Thanks (0) Thanks(0)   Quote Bo3Dyx Quote  Post ReplyReply Direct Link To This Post Topic: Compact and Repair Access Database
    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 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

Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Wimborne
Status: Offline
Points: 9385
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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?


Edited by WebWiz-Bruce - 20 April 2017 at 2:15pm
Back to Top
Bo3Dyx View Drop Down
Groupie
Groupie
Avatar

Joined: 15 July 2008
Location: Russia, Saratov
Status: Offline
Points: 41
Post Options Post Options   Thanks (0) Thanks(0)   Quote Bo3Dyx Quote  Post ReplyReply Direct Link To This Post Posted: 20 April 2017 at 4:22pm
On another hosting, here is the error message:
Originally posted by 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.

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

  2. An error occurred on the server when processing the URL. Please contact the system administrator.

    If you are the system administrator please click here to find out more about this error.


And yes, I know that there are no files with * .aspcd extension
Back to Top
Bo3Dyx View Drop Down
Groupie
Groupie
Avatar

Joined: 15 July 2008
Location: Russia, Saratov
Status: Offline
Points: 41
Post Options Post Options   Thanks (0) Thanks(0)   Quote Bo3Dyx Quote  Post ReplyReply Direct Link To This Post Posted: 21 April 2017 at 6:40am
Installed version 10.18 - everything is working fine, the database is being repaired and compressed ....
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Wimborne
Status: Offline
Points: 9385
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
Bo3Dyx View Drop Down
Groupie
Groupie
Avatar

Joined: 15 July 2008
Location: Russia, Saratov
Status: Offline
Points: 41
Post Options Post Options   Thanks (0) Thanks(0)   Quote Bo3Dyx Quote  Post ReplyReply Direct Link To This Post 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.


Edited by WebWiz-Bruce - 21 April 2017 at 2:31pm
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Wimborne
Status: Offline
Points: 9385
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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;

https://www.webwiz.net/web-hosting/windows-web-hosting.htm


Edited by WebWiz-Bruce - 21 April 2017 at 3:28pm
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Wimborne
Status: Offline
Points: 9385
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.


Edited by WebWiz-Bruce - 21 April 2017 at 3:30pm
Back to Top
 Post Reply Post Reply Page  12>
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 11.10
Copyright ©2001-2017 Web Wiz Ltd.



Become a Fan on Facebook Follow us on Twitter Find us on Google+ Community Forums Web Wiz Blogs Web Wiz News
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Policy

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Unit B10, 9 Nimrod Way, East Dorset Trade Park, Wimborne, Dorset, BH21 7UH, UK.

Prices exclude VAT unless otherwise stated. VAT No. 988999105 - $, € prices shown as a guideline only.


Copyright ©2001-2017 Web Wiz Ltd. All rights reserved.