Fixing a corrupt 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=4991
Printed Date: 02 April 2026 at 4:18pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Fixing a corrupt database
Posted By: Aaron P
Subject: Fixing a corrupt database
Date Posted: 13 August 2003 at 10:02am
|
I am getting the following error when trying to access my forums. /cgi-bin/forum/forum/active_users.inc, line 196 After searching these forums it appears that my problem is that the database has become corrupted because of the show active users feature (which I can disable in v7) The fix is to open it in access and then perform a "compact and repair" procedure but when I try to open it in access 2000 it says that the database is an unrecognized format. Am I doing this right? I know nothing about access. In the meantime I am trying to get a restore on the database from my webhosts backup. If I just replace the current database with a good one from before it became corrupted everything should just go back to the way it was right? |
Replies:
Posted By: WebWiz-Bruce
Date Posted: 13 August 2003 at 11:04am
|
Your best bet maybe to get an old backup before it became corrupted otherwise it vould be that it is so corrupted that you can not open the database to compact and repair it. It would probally be better if you left the active users feature off in the Access version. ------------- 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: Magic
Date Posted: 13 August 2003 at 12:55pm
|
Just out of interest, and idea of the size of your database file ? Mark ------------- - Don't ask me how it works, just be greatful it works! - Now what does this BIG RED button do? 
|
Posted By: WebWiz-Bruce
Date Posted: 13 August 2003 at 3:47pm
|
26Mb ------------- 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: Bliss
Date Posted: 13 August 2003 at 4:34pm
|
Borg, it that yours or Aaron's |
Posted By: Aaron P
Date Posted: 14 August 2003 at 12:24am
|
My database is 32 Mb. I was able to get a restore from my webhost, which works. Now I am trying to upgrade to v7 to avoid the problem in the future. I am getting a line 609 error however. One of the users recommended compacting the database before converting it. But my database still cannot be opened in access (the good one, not the one that crashed/became corrupt). This sounds bad to me... I really want to get v7 going but I dont want to lose all my users. Any suggestions? |
Posted By: Aaron P
Date Posted: 14 August 2003 at 12:26am
|
Oh yeah, access tells me that the "database is an unrecognized format". But it is the same database I have in use. |
Posted By: WebWiz-Bruce
Date Posted: 14 August 2003 at 1:08am
|
Make sure that you are using access XP to open the database in. ------------- 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: b_bonnett
Date Posted: 14 August 2003 at 4:11am
|
The "database is not in a recognised format" means that it was saved in a later version of Access than 2000. This means that the drivers on your site can use it, but you can't open it. You could try asking your web hosts if they could do the upgrade for you. Blair ------------- Webmaster, http://www.planegallery.net/ - The Plane Gallery Greetings From Christchurch |