Web Wiz Forums - Urgent BUG

Print Page | Close Window

Urgent BUG

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

Topic: Urgent BUG

Posted By: tomasr
Subject: Urgent BUG
Date Posted: 20 October 2003 at 3:40am

Hello,

I am using Web Wiz Forums version 7.5. And sometimes error appears then I want to post new potic

Microsoft JET Database Engine error '80040e21'

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.

/scripts/forum/post_message.asp, line 756

Replies:

Posted By: WebWiz-Bruce
Date Posted: 20 October 2003 at 4:53am

You haven't said if this is a update from a previous version or when exactly this error occurs to be able to replicate it. eg. what you are posting? what options you are selecting? what language you are posting?

It could also be a corruption in the access database, try compacting and repairing the database from the admin section.

-------------
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: tomasr
Date Posted: 20 October 2003 at 5:53am

I have updated forum db from 6 to 7 version with "Access Database Migration Tool" tools. I also have tryied to repair db but no luck.

Posted By: WebWiz-Bruce
Date Posted: 20 October 2003 at 6:07am

Sounds like the upgrade has not worked correctly.

You need to compact and repair both databases before and after the update in Access. The compact and repair tool can be found under the tools menu in access.

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