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
 New members can't reply to topics !
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Jóhannes
Junior Member

Iceland
139 Posts

Posted - 30 August 2006 :  06:05:06  Show Profile  Visit Jóhannes's Homepage  Send Jóhannes an AOL message
Hi

In the Access DB I had the table "FORUM_MEMBERS". I did copy that table and gave it the name "FORUM_MEMBERS_NEW" because I was doing some tests.

After the test I renamed:
"FORUM_MEMBERS" to "FORUM_MEMBERS_OLD" and
"FORUM_MEMBERS_NEW" to "FORUM_MEMBERS"

I use the table named "FORUM_MEMBERS" with my forum.

I did NOT change the table's structure (only the data)

But now all my new members (all my members are located in the table "FORUM_MEMBERS") get the following error when they try to reply topics:

Microsoft JET Database Engine error '80004005' 
You cannot add or change a record because a related record is required in table 'FORUM_MEMBERS_OLD'. 
/snitz/post_info.asp, line 990 

But there is no table "FORUM_MEMBERS_OLD" I'm using anymore.
Why does the program think that?
Line 990 is:
		my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords

Anyone

Jóhannes


Edited by - Jóhannes on 30 August 2006 06:14:56

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 30 August 2006 :  06:20:40  Show Profile  Send ruirib a Yahoo! Message
Probably the old forum members table had relationships set with other tables, so you will need to delete those relationships, in Access.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

Jóhannes
Junior Member

Iceland
139 Posts

Posted - 30 August 2006 :  06:32:42  Show Profile  Visit Jóhannes's Homepage  Send Jóhannes an AOL message
That was it

Thanks !


Jóhannes

Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 30 August 2006 :  06:53:54  Show Profile  Send ruirib a Yahoo! Message
You're welcome.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page
  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.21 seconds. Powered By: Snitz Forums 2000 Version 3.4.07