Web Wiz Forums - PM Errors

Print Page | Close Window

PM Errors

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

Topic: PM Errors

Posted By: zamalek
Subject: PM Errors
Date Posted: 22 June 2003 at 9:23am

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.

/forum/pm_post_message.asp, line 323

The above error happes when I use the PM

Please help.

Replies:

Posted By: WebWiz-Bruce
Date Posted: 23 June 2003 at 2:08am

If you have upgraded from a previous version it could be that it has not worked correctly, try again.

You may have accidemt;y deleted one of the built in accounts, check by opening the database in access that you still have the admin and guest accounts at position 1 and 2 in the table tblAuthor.

You could have a corrupted database, download the database, open it in access and select 'compact and repair' from the tools menu.

-------------
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: blueangel
Date Posted: 05 August 2003 at 3:12pm

I'm getting the same thing...zamalek, did you ever get this fixed?

Borg, the guests and renamed admin account are still there -- everything else works great so the only thing I didn't do is resync the db -- but like I said everything else works....any other suggestions?

Kita

added:
The only way I got it to work was to delete all the rows from the PM table --- I backed up the table so if anyone has another solution I'd still be interested in hearing it. Fortunately I only have a lil over 100 users so they shouldn't get too ticked if I warned them about their PMs when I go live with the new version!