delete error in 7.01 access

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
SilentSimon Members Profile Find Members Posts Mod Builder Group Joined: 23 April 2003 Status: Offline Points: 29	Post Options Post Reply Quote SilentSimon Report Post Thanks(0) Quote Reply Topic: delete error in 7.01 access 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.turbuLANce.nl \| http://www.Silent-Simon.nl =-

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply 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.
	Web Wiz Forums Hosting ASP.NET Web Hosting

SilentSimon Members Profile Find Members Posts Mod Builder Group Joined: 23 April 2003 Status: Offline Points: 29	Post Options Post Reply Quote SilentSimon Report Post Thanks(0) Quote Reply 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.turbuLANce.nl \| http://www.Silent-Simon.nl =-

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply 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.
	Web Wiz Forums Hosting ASP.NET Web Hosting

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.