Group Permissions - OLE DB Error 80040e21
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=16787
Printed Date: 16 April 2026 at 6:33am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Group Permissions - OLE DB Error 80040e21
Posted By: MortiOli
Subject: Group Permissions - OLE DB Error 80040e21
Date Posted: 03 October 2005 at 1:42pm
|
Hi,
I'm hoping someone can help me with this problem, please?
I've recently converted from MS Access to MS SQL, with the help of dj air, but I've hit a problem when modifying group permissions;
Microsoft OLE DB Provider for SQL Server error '80040e21'
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. /forum/admin/create_group_permissions.asp, line 112 This occurs when I go to group permissions, and add any permissions to the moderator group (and maybe other groups too).
Could someone give me some info on how I can sort this problem out please, as I'm currently moderator-less
 Thanks!
|
Replies:
Posted By: dj air
Date Posted: 03 October 2005 at 4:18pm
|
just to make it so i get replies but also the primary key/ increment is working ok and the values entered are ok im not to sure on this one, |
Posted By: MortiOli
Date Posted: 06 October 2005 at 1:27pm
Anyone have any ideas please? I'm the only person moderating my forums, and it's getting a bit mad... 
|
Posted By: JJLatWebWiz
Date Posted: 06 October 2005 at 5:59pm
|
This sounds like a bug in the MDAC. But, if I assume the asp is unchanged from a fresh 7.92 install, line 112 says, ".Fields("Group_ID") = intUserGroupID". Is that correct?
dj air, you said that the "primary key / increment" is working. In my SQL test install, there is no primary key or increment on the tblPermissions table. That could expose the MDAC flaw. ------------- p.s. I'm not affiliated with Web Wiz Guide in any way. I'm just an average Web Wiz user repaying my debt for the use of their fine forum by trying to help other Web Wiz Guide users. |
Posted By: dj air
Date Posted: 06 October 2005 at 6:35pm
|
lgood point oli, ill take off the primary/increment |
Posted By: MortiOli
Date Posted: 07 October 2005 at 1:58pm
Seems to have done the trick! Cheers guys 
|