This topic is locked

Adding record and User Permissions problems

3/15/2006 2:02:04 PM
ASPRunnerPro General questions
D
dunga author

Hello, this is my first post and will be nice:)
I am running winXP professional, IIS 5.1(as it sates in about box)
I run into 2 distinct problems, please try to address them.
Login is not a problem at all, but Administrator cannot add new record. admin can edit any already beforehand created(in access) record, but nothing can be done as to adding a new one.

here is the error.

HTTP 500.100 - Internal Server Error - ASP error

Internet Information Services
--------------------------------------------------------------------------------
Technical Information (for support personnel)
Error Type:

Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)

Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

/asprunner1/Animals_add.asp, line 236
Browser Type:

Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)
Page:

POST 5323 bytes to /asprunner1/Animals_add.asp
POST Data:

error '80020009'

Exception occurred.
/iisHelp/common/500-100.asp, line 223


I have set all correct persmisiions to

databas

folder

files

on the folder level, and on the IIS services level.
Second issue is that when a NON admin logs in, he still can edit some records(randomly) which confuses me.
what happens for example is:
let's say user A(with set permission as view/search only) logs in, he somehow on the main page manages get some records edited.
Please help.
I am seriously evaluating the possibility of purchasing the asp runner in about a week.

Sergey Kornilov admin 3/16/2006

Hi,

  1. this error appears when you try to insert too much data into a specified field. For example if you enter a string that is 20 characters long into a field that is defined as varChar(10), or if you try to insert a value greater than 2^15 (approx 2.1 billion) into an Integer field.
  2. I wasn't able to reproduce it. Please zip and send generated ASP files to [email=support@xlinesoft.com]support@xlinesoft.com[/email] along with project file and your sample database for investigation.