Can't solve access right problem - please help

[bostjank]

I have NT Server 4.0 IIS 4.0 installed on our server. Furthermore I have ASP pages that are part of our intranet. The problem is that whenever an ASP page want to write to a database, there is error message saying
"The operation must use updateable query"

The logical solution would be setting the appropriate level o permissions to the INTERNET_GUEST_ACCOUNT users. There is no such group of users available, but I gave the group "Everybody" right to write to the database file and folder.

The problem stil persisted. Next I tried to set the "conn.Mode" to "3" (read/write), but nothing changed.

Could you please help me and tell me what else could be wrong, or if there is some other way of setting permissions (I used Explorer/properties/security).

My server is an intranet server only, and IIS 4.0 was installed after the NT Server was installed.


Thanks very much,
Bostjan:thumbsup:

[webmarkart]

Just out of curiosity, did you grant write access to that particular folder on the server where the database is?

If the folder itself doesnt have write access nothing will write to the database no matter how you code the asp.

[bostjank]

Yes I did - on the folder and the file.

[Roy Sinclair]

If it isn't permissions then it's the way you run the query, the cursor type you used may create a non-updateable record set.

[bostjank]

The same set of ASP files and MDB file work perfectly on my computer and on any public internet server...

[whammy]

Did you check Users AND Security for that folder? Sometimes I couldn't get it to work either, but delete all the entries that are there now, and redo it making sure you check both things.