Microsoft JET Database Engine Error

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
capi Members Profile Find Members Posts Newbie Joined: 15 August 2007 Status: Offline Points: 6	Post Options Post Reply Quote capi Report Post Thanks(0) Quote Reply Topic: Microsoft JET Database Engine Error Posted: 28 February 2008 at 9:55pm
	Forum was working fine, now if I try and post a new topic I get the following error: The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again. Any idea why

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: 29 February 2008 at 7:39am
	This error is common with Access database as Access is a desktop database, which is why the Access version of Web Wiz Forums is for non-production test environments. Hopfully you may be able to fix this by downloading the database, opening in Access, and selecting 'Compact and Repair database' before reuploading it to the server.
	Web Wiz Forums Hosting ASP.NET Web Hosting

capi Members Profile Find Members Posts Newbie Joined: 15 August 2007 Status: Offline Points: 6	Post Options Post Reply Quote capi Report Post Thanks(0) Quote Reply Posted: 03 March 2008 at 3:33am
	As it turns out here is what was going on with my site. I am occaisionally having users set up an account and then injecting the database with drug ads. Once I removed those posts from the database itself everything was fine. It apparently makes the database think there are duplicate entries in the database and it won't allow new posts until these bogus threads are removed.

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.