Error running compact and repair

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
russnj2 Members Profile Find Members Posts Groupie Joined: 17 April 2006 Status: Offline Points: 88	Post Options Post Reply Quote russnj2 Report Post Thanks(0) Quote Reply Topic: Error running compact and repair 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

russnj2 Members Profile Find Members Posts Groupie Joined: 17 April 2006 Status: Offline Points: 88	Post Options Post Reply Quote russnj2 Report Post Thanks(0) Quote Reply 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

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply 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.
	Web Wiz Forums Hosting ASP.NET Web Hosting

russnj2 Members Profile Find Members Posts Groupie Joined: 17 April 2006 Status: Offline Points: 88	Post Options Post Reply Quote russnj2 Report Post Thanks(0) Quote Reply 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

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply 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.
	Web Wiz Forums Hosting ASP.NET Web Hosting

russnj2 Members Profile Find Members Posts Groupie Joined: 17 April 2006 Status: Offline Points: 88	Post Options Post Reply Quote russnj2 Report Post Thanks(0) Quote Reply 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

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.