Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MS Access
 Microsoft OLE DB Provider for ODBC Drivers error '
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

eac
Starting Member

USA
12 Posts

Posted - 28 June 2001 :  21:08:50  Show Profile  Visit eac's Homepage  Send eac a Yahoo! Message
Here's the Error on my problem..

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] You cannot add or change a record because a related record is required in table 'FORUM_MEMBERS'.

/yd/admin_moderators.asp, line 169

Here are lines 160 to 171 of admin_moderators.asp



160 '## Forum_SQL
161 strSql = "INSERT INTO " & strTablePrefix & "MODERATOR "
162 strSql = strSql & "(FORUM_ID"
163 strSql = strSql & ", MEMBER_ID"
164 strSql = strSql & ") VALUES ("
165 strSql = strSql & Request("Forum")
166 strSql = strSql & ", " & Request("UserID")
167 strSql = strSql & ")"
168
169 my_Conn.Execute strSql
170 %>
171 <br>

When I go to change the moderators for the forum, the moderators names do not show up on the left side.. Note: some users do have moderators rights? Can somebody help.. Thanks..


  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.26 seconds. Powered By: Snitz Forums 2000 Version 3.4.07