Author |
Topic Search Topic Options
|
Bo3Dyx
Groupie
Joined: 15 July 2008
Location: Russia, Saratov
Status: Offline
Points: 42
|
Post Options
Thanks(0)
Quote Reply
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 |
---|
| |
---|
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9791
|
Post Options
Thanks(0)
Quote Reply
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
|
|
|
Bo3Dyx
Groupie
Joined: 15 July 2008
Location: Russia, Saratov
Status: Offline
Points: 42
|
Post Options
Thanks(0)
Quote Reply
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
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
|
|
Bo3Dyx
Groupie
Joined: 15 July 2008
Location: Russia, Saratov
Status: Offline
Points: 42
|
Post Options
Thanks(0)
Quote Reply
Posted: 21 April 2017 at 6:40am |
Installed version 10.18 - everything is working fine, the database is being repaired and compressed ....
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9791
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
Bo3Dyx
Groupie
Joined: 15 July 2008
Location: Russia, Saratov
Status: Offline
Points: 42
|
Post Options
Thanks(0)
Quote Reply
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
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9791
|
Post Options
Thanks(0)
Quote Reply
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
|
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9791
|
Post Options
Thanks(0)
Quote Reply
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
|
|
|