Web Wiz Forums - The changes you requested to the table not success

Print Page | Close Window

The changes you requested to the table not success

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

Topic: The changes you requested to the table not success

Posted By: jaimalleshk
Subject: The changes you requested to the table not success
Date Posted: 06 October 2007 at 9:08am

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.

I receive above error whenever I try to create a new post. I suspect tblThread to have some problems. I am using Access database.

Replies:

Posted By: WebWiz-Bruce
Date Posted: 06 October 2007 at 1:34pm

This is common with an Access database and means the database is corrupted.

Download the database, open it in MS Access and select the 'Compact and Repair Tool' to fix the database.

-------------
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: jaimalleshk
Date Posted: 06 October 2007 at 1:49pm

I tried compact and receive several times.

This is the result and problem is still there:-

Server Error in Forum Application
An error has occured while writing to the database.
Please contact the forum administrator.

Support Error Code:- err_Access_save_new_topic_data
File Name:- new_post.asp

Error details:-
Microsoft JET Database Engine
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.

Posted By: jaimalleshk
Date Posted: 06 October 2007 at 1:50pm

I mean:- compact and repair

Posted By: WebWiz-Bruce
Date Posted: 06 October 2007 at 3:14pm

Then I'm afraid it means that the database is corrupted beyond repair.

To prevent such issues you should use the mySQL or SQL Server versions, as Access is only able to handle very light load.

-------------
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