Web Wiz Forums - Microsoft JET Database Engine Error

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.