Web Wiz Forums - Error running compact and repair

Print Page | Close Window

Error running compact and repair

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=22781
Printed Date: 08 April 2026 at 1:18am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Error running compact and repair

Posted By: russnj2
Subject: Error running compact and repair
Date Posted: 26 February 2007 at 11:25am

I am getting this error message when I run compact and repair on my access db. Any ideas? Thanks Russ

Microsoft JET Database Engine error '80004005'

Could not find field 'Description'.

/forums/admin_compact_access_db.asp, line 129

Replies:

Posted By: russnj2
Date Posted: 26 February 2007 at 11:41am

reuploaded the file and now getting this error.

Microsoft JET Database Engine error '80004005'

Could not find field 'Description'.

/forums/admin_compact_access_db.asp, line 109

Posted By: WebWiz-Bruce
Date Posted: 26 February 2007 at 12:02pm

Looks like the database has become corrupted beyond repair.

Access has a bad habit of becoming corrupted as it is a flat desktop office file and not a real database system. If you can you should run a real database management system such as mySQL or SQL Server which are servers rather than flat files and so do not suffer this problem.

-------------
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: russnj2
Date Posted: 26 February 2007 at 1:19pm

Ok, I downloaded the db to my computer and access 2002 ran the compact and repair without a problem. Is the webwiz compact and repair different than the version that runs with access?

Thanks
Russ

Posted By: WebWiz-Bruce
Date Posted: 26 February 2007 at 1:28pm

It uses the compact and repair built into the MDAC Database Drivers, which may do things different to Access on your own PC. Could also depend on what MDAC drivers are installed on the server vs. your PC.

I would still recommend using mySQL or SQL Server as it would prevent these types of issues, give you better performance, allow more simulations connections, allow many 100,000's of more posts, as well as a host of other benefits.

-------------
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: russnj2
Date Posted: 26 February 2007 at 1:31pm

Yes, I agree I am going to look for a SQL solution. Just wanted to let you know what happened. One scare is enough for me.

Thanks
Russ