Hi,
I got some problems when I should delete a member in my forum, I use version 7.01
The 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
Line 124: (120-128 )
'Set all the users posts to the Guest account
strSQL = "UPDATE " & strDbTable & "Thread SET Author_ID=2 WHERE (Author_ID =" & lngMemberID & ")"
'Write to database
adoCon.Execute(strSQL) <---- Line 124
'Delete the user from the email notify table
strSQL = "DELETE FROM " & strDbTable & "EmailNotify WHERE (Author_ID =" & lngMemberID & ")"
Anyone that know my problems here ?
Topic Options
Post Options
Thanks(0)
