Print Page | Close Window

Deleting members problem

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=2197
Printed Date: 31 March 2026 at 3:07pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Deleting members problem
Posted By: oneminuteguy
Subject: Deleting members problem
Date Posted: 27 April 2003 at 6:22am
When trying to delete a member I sometimes get this:  (V7.0 -access)

Microsoft JET Database Engine error '80004005'

You cannot add or change a record because a related record is required in table 'tblAuthor'.

/forum/delete_member.asp, line 124

Line 124 is

adoCon.Execute(strSQL)

What's causing this? - Though it only happends sometimes, it's very annoying not to be able to delete members.

Regards,

OMG




Replies:
Posted By: WebWiz-Bruce
Date Posted: 27 April 2003 at 6:34am
Make sure in the tbale tblAuther that you haven't deleted the guest account with ID number 2, if you have then many functions of the forum like this will fail to run correctly.

-------------
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: oneminuteguy
Date Posted: 27 April 2003 at 7:00am
I just DL'ed the DB - and u were right; ID 2 had been deleted.

Damn - me so dumb - I was deleting test members and deleted the guest account. Learning by doing I guess...

thx for helping boRg

Regards,
OMG



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