| Author |
 Topic Search  Topic Options
|
tripleh 
Newbie
Joined: 13 March 2006
Status: Offline
Points: 2
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Unrecognized database
Posted: 13 March 2006 at 5:18pm |
|
I have this problem in index.asp
Microsoft JET Database Engine error '80004005'
Unrecognized database format 'E:\vweb\mysite\mdb-database\wwForum.mdb'.
/forum/common.asp, line 260
In another server the web wiz forum works well, while in this server ( using same files ) it doesn't work.
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 13 March 2006 at 6:10pm |
|
I think you mean default.asp (index is used on Unix servers, default on Windows servers)
The error usually indicates that the database has become corrupted, you need to download the database, open in Access, and use the 'Compact and Repaid Tool' from the tools menu. This should fix the corruption in the database.
However, you should look at using the SQL Server version as Access is a desktop flat file and unable to cope with the demands of a forum that has more than a handful of users per day.
|
|
tripleh
Newbie
Joined: 13 March 2006
Status: Offline
Points: 2
|
Post Options
Thanks(0)
Quote Reply
Posted: 14 March 2006 at 11:32am |
|
I've repaired database but it doesn't work yet.
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 14 March 2006 at 2:55pm |
|
Make sure that the server has the JET 4 database drivers installed and the the Access database is version 2000 or newer.
If you have all of these then it sounds like your Access database has become corrupted beyond repair and you may have to start afresh.
I would recommend that you use SQL Server, or in version 8 MySQL or SQL Server as you will not have these corruption issues and your forum will be able to handle over 1,000,000 posts instead of just 5,000 with the Access version.
Edited by -boRg- - 14 March 2006 at 2:56pm
|
|
uncas
Newbie
Joined: 21 March 2006
Status: Offline
Points: 4
|
Post Options
Thanks(0)
Quote Reply
Posted: 22 March 2006 at 5:12pm |
Do you guys have any luck with this issue ?
I am having the same exact problem.
Thanks,
Uncas
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 23 March 2006 at 11:51am |
|
This is often coursed by a corrupted database, which is common with Access as it was designed as a desktop database and not really up to the task on being used for a web site.
Try to fix the database by downloading it, opening it in Access, and select, 'compact and repair database' from the tools menu.
Hopefully this should fix the issue, and for a more permanent solution try using a real database system like SQL Server or for version 8 it also supports mySQL 4.1 or above.
|
|
oorubenoo
Newbie
Joined: 22 December 2011
Location: Florida
Status: Offline
Points: 13
|
Post Options
Thanks(0)
Quote Reply
Posted: 23 October 2013 at 6:04am |
|
Anyway to convert the database from Access to MySQL. Do you offer those services, if I host with your server>?
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 23 October 2013 at 7:39am |
Moving from Access to SQL Server is possible as it uses very much the same database schema. Moving to mySQL is not possible as it uses a completely different schema. Our Web Wiz Forums hosting packages come with SQL Server and the migration service that can be purchased along with the Web Wiz Forums hosting does include upsizing the database from Access to SQL Server. http://www.webwiz.net/web-wiz-forums/forum-hosting.htm
|
|
|
|
