Database Discussion - Corrupt Access Database?

Print Page | Close Window

Corrupt Access Database?

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=6394
Printed Date: 30 March 2026 at 1:57pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Corrupt Access Database?

Posted By: davidshq
Subject: Corrupt Access Database?
Date Posted: 14 October 2003 at 12:15am

Hi Folks,
I'm having a problem with a search directory script I've been using at my site http://www.civilwarsearch.com - www.civilwarsearch.com . It suddenly seemed to stop working correctly though I don't know of any changes I made that should cause this problem. In any case I wrote my host and asked them if they had changed anything and they mentioned that perhaps my Access database had become corrupt. Could someone explain to me how my db would become corrupt? How would I know? And is there anything I can do to fix it?
Respectfully,
David.

Replies:

Posted By: michael
Date Posted: 14 October 2003 at 8:17am

Access is prone to becoming corrupt, download you mdb and open it, it should tell you if something is wrong, you might want to do a compact and repair in Access...

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker

Posted By: davidshq
Date Posted: 14 October 2003 at 9:46am

Thanks for the advice...The one problem is that I don't own Access. :-/ I use aspAccessEditor or Microsoft's ASP.NET Web Matrix - but as far as I know neither has the ability to repair databases. Is there any online compact/repair utilities, etc.?

Respectfully,
David.

Posted By: michael
Date Posted: 14 October 2003 at 12:27pm

There are a ton, I think even this forum has one built in. But you can also dl a script from i.e. aspin.com

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker

Posted By: davidshq
Date Posted: 14 October 2003 at 12:49pm

I actually visited hotscripts.com and found a free database compactor. It worked well and cut my database down to around half its original size...but the script is still not working. :-/
Instead of changing a Category ID to the correct number it is changing it to a negative number for some unknown reason.
Respectfully,

David.

Posted By: dpyers
Date Posted: 14 October 2003 at 10:46pm

If any of your integers are exceeding 32,768, you may have to change them to a different Type capable of holding a larger number.

-------------

Lead me not into temptation... I know the short cut, follow me.

Posted By: davidshq
Date Posted: 15 October 2003 at 6:12am

Thanks everyone...I've fixed the error. Compacting the database took it down to around half its size - which was nice...But it ended up that my problem was in the fact that I put a - to separate different terms in the text and the script was reading the - as a numerical value, thus throwing negative numbers.

Respectfully,
David.