Web Wiz Forums - delete error in 7.01 access

Print Page | Close Window

delete error in 7.01 access

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=9692
Printed Date: 07 April 2026 at 11:48pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: delete error in 7.01 access

Posted By: SilentSimon
Subject: delete error in 7.01 access
Date Posted: 10 February 2004 at 5:58am

when i want to delete a member i get the following error:

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

------
just weird cuz i didn't change anything since the last time i deleted a member, any suggestions?

-------------
-= http://www.hop-team.nl - http://www.turbuLANce.nl | http://www.Silent-Simon.nl - http://www.Silent-Simon.nl =-

Replies:

Posted By: WebWiz-Bruce
Date Posted: 10 February 2004 at 6:17am

The problem is that you have deleted the built in Guest account from your forum.

This means that things likle deleting members will now no-longer work.

There is code in the forum to prevent you from deleting the built in guest account so I'm not user how you have done this.

-------------
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: SilentSimon
Date Posted: 10 February 2004 at 11:10am

hmz, your probably right, cuz i cant find the record containing the guest account.
is there anyway to set this back?

-------------
-= http://www.hop-team.nl - http://www.turbuLANce.nl | http://www.Silent-Simon.nl - http://www.Silent-Simon.nl =-

Posted By: WebWiz-Bruce
Date Posted: 10 February 2004 at 11:19am

The guest account needs to have the Author_ID 2, without this built in guest account much functionality of the forum will be lost.

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