Deleting members problem

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
oneminuteguy Members Profile Find Members Posts Mod Builder Group Joined: 18 October 2002 Location: Denmark Status: Offline Points: 100	Post Options Post Reply Quote oneminuteguy Report Post Thanks(0) Quote Reply Topic: Deleting members problem 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 Edited by oneminuteguy

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: 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.
	Web Wiz Forums Hosting ASP.NET Web Hosting

oneminuteguy Members Profile Find Members Posts Mod Builder Group Joined: 18 October 2002 Location: Denmark Status: Offline Points: 100	Post Options Post Reply Quote oneminuteguy Report Post Thanks(0) Quote Reply 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

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.