Print Page | Close Window

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 Smile

Debbie



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net