Web Wiz Forums - Unrecognized database

Print Page | Close Window

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

Topic: Unrecognized database

Posted By: tripleh
Subject: Unrecognized database
Date 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.

Replies:

Posted By: WebWiz-Bruce
Date 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.

Posted By: tripleh
Date Posted: 14 March 2006 at 11:32am

I've repaired database but it doesn't work yet.

Posted By: WebWiz-Bruce
Date 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.

Posted By: uncas
Date 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

Posted By: WebWiz-Bruce
Date 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.

Posted By: oorubenoo
Date 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>?

Posted By: WebWiz-Bruce
Date 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" rel="nofollow - http://www.webwiz.net/web-wiz-forums/forum-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: oorubenoo
Date Posted: 23 October 2013 at 10:25pm

Do you have instructions for converting from acess to SQL, I'm familiar with both, if I were to import all the data in the same format, and changed the settings for the SQL would that work?

Posted By: WebWiz-Bruce
Date Posted: 25 October 2013 at 3:16pm

You can use the Access upsize wizard to upsize to SQL Server.

You do need to go through the database afterwards and clean up some bits like constraints which are added to database fields, but apart from that most of the conversion is handled correctly.

-------------
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