Can anyone help with an 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=23797
Printed Date: 07 April 2026 at 7:47am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Can anyone help with an error?
Posted By: debbieg_ukplc
Subject: Can anyone help with an error?
Date Posted: 16 July 2007 at 11:56am
|
Hi There I am getting the following error message when i try to delete a member. Any idea how to fix it. Microsoft JET Database Engine error '80004005' 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. /delete_member.asp, line 136 Thanks in advance Debbie |
Replies:
Posted By: WebWiz-Bruce
Date Posted: 16 July 2007 at 12:50pm
|
Could be a corrupted database as this is common with Access databases. You would need to download the database and open it in Access and select, 'Compact and Repair Database' from the Tools menu. Also you may want to just suspend the member which is recommended over deleting the member so that their posts remain under their name, and also stop them from signing up again under the same name. ------------- 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: debbieg_ukplc
Date Posted: 16 July 2007 at 2:21pm
|
Thanks so much I'll give it a try. If it doesn't work I'll just suspend the member. Can we stop suspended members showing in the members list? Debbie |
Posted By: WebWiz-Bruce
Date Posted: 16 July 2007 at 2:24pm
|
It's not something that has ever been asked before so it's not built into the software.
------------- 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: debbieg_ukplc
Date Posted: 16 July 2007 at 2:38pm
|
That's ok, it's not important. Thanks so much for your help  Debbie |