Print Page | Close Window

Microsoft JET Database Engine Error

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=25359
Printed Date: 03 April 2026 at 9:35pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Microsoft JET Database Engine Error
Posted By: capi
Subject: Microsoft JET Database Engine Error
Date 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



Replies:
Posted By: WebWiz-Bruce
Date 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.


-------------
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: capi
Date 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.



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net