Web Wiz Support and Community Forums : Error running compact and repair https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 08 Apr 2026 03:03:28 +0000 Mon, 26 Feb 2007 13:31:28 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=22781 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Error running compact and repair : Yes, I agree I am going to look...]]> https://forums.webwiz.net/error-running-compact-and-repair_topic22781_post120851.html#120851 Author: russnj2
Subject: 22781
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
]]> Mon, 26 Feb 2007 13:31:28 +0000 https://forums.webwiz.net/error-running-compact-and-repair_topic22781_post120851.html#120851 <![CDATA[Error running compact and repair : It uses the compact and repair...]]> https://forums.webwiz.net/error-running-compact-and-repair_topic22781_post120850.html#120850 Author: WebWiz-Bruce
Subject: 22781
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.
]]> Mon, 26 Feb 2007 13:28:14 +0000 https://forums.webwiz.net/error-running-compact-and-repair_topic22781_post120850.html#120850 <![CDATA[Error running compact and repair : Ok, I downloaded the db to my...]]> https://forums.webwiz.net/error-running-compact-and-repair_topic22781_post120849.html#120849 Author: russnj2
Subject: 22781
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
]]> Mon, 26 Feb 2007 13:19:07 +0000 https://forums.webwiz.net/error-running-compact-and-repair_topic22781_post120849.html#120849 <![CDATA[Error running compact and repair : Looks like the database has become...]]> https://forums.webwiz.net/error-running-compact-and-repair_topic22781_post120844.html#120844 Author: WebWiz-Bruce
Subject: 22781
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.
]]> Mon, 26 Feb 2007 12:02:03 +0000 https://forums.webwiz.net/error-running-compact-and-repair_topic22781_post120844.html#120844 <![CDATA[Error running compact and repair : reuploaded the file and now getting...]]> https://forums.webwiz.net/error-running-compact-and-repair_topic22781_post120843.html#120843 Author: russnj2
Subject: 22781
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


]]> Mon, 26 Feb 2007 11:41:14 +0000 https://forums.webwiz.net/error-running-compact-and-repair_topic22781_post120843.html#120843 <![CDATA[Error running compact and repair : I am getting this error message...]]> https://forums.webwiz.net/error-running-compact-and-repair_topic22781_post120842.html#120842 Author: russnj2
Subject: 22781
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


]]> Mon, 26 Feb 2007 11:25:53 +0000 https://forums.webwiz.net/error-running-compact-and-repair_topic22781_post120842.html#120842