Read-only error for updating Access database through ASP web page

[cjeffwang]

I was testing a Register asp page with an Access database. In my Form
Action asp page, I have coded:
If rsUsers.EOF Then
rsUsers.AddNew ---- line 13
......

After typing registration information, there was an error on my Form
Action asp page at the above line 13:
*****************************************************
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services

Error Type:
Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only.
/application/AddUser.asp, line 13
*************************************************

Then a MS MVP suggested me add the IUSR_MachineName user w/ read/write
permissions to the Access database file. I added the IUSR_MachineName
to Access, but still had the same Read-Only error. Then MVP asked me
add the user to the NTFS permissions list.

Here are my questions:
1. Is the IIS IUSR_Machinename applicable to NT and W2k only, not XP?
2. How to add user to NTFS permissions list for Access databse?
3. Any other instructions to fix the Read-Only error for updating the
Access data?

TIA,
Jeffrey

 

[cjeffwang]

Here is my connection string:

set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "provider=Microsoft.Jet.OLEDB.4.0; " & _
"Data Source= G:\datastores\classified.mdb"
"Persist Security Info=False"

This connection string seemed to work fine. The problem is new
data can not be stored into the database.

TIA,
Jeffrey

 

[TC]

Make sure that the relevant Windows users (who are using your database)
have full Windows permissions (read/write/create/delete/etc.) to the
folder containing the MDB file. Also make sure that the MDB file does
not have the Windows "read only" attribute set.

HTH,
TC

 

[cjeffwang]

Thanks for the email.

My Access MDB file is stored in an add-on G:\datastores folder.
I can de-select the 'read only' attribute of the datastores folder.
But the 'read-only' attribute was selected again after I clicked the
properties.

Why?

TIA,
Jeffrey

 

[TC]

Um, I did not send you an email as far as I know. I just replied in
this thread. This is "usenet" (or "newsgroups") - not email.

So, you are saying that the folder containing the database, is marked
read-only in the Windows properties, and you can not successfully take
that setting off?

Sorry, I don't know what would be causing that. Maybe an administratopr
has set the folder that way, and your login does not have sufficient
priviliges to unset it?

HTH,
TC
(off for the day)

 

[Brendan Reynolds]

I'm not sure if this will help to resolve the problem, but just in case it
might - what do you mean by 'add-on'?

 

[cjeffwang]

I bought and installed the G drive. Just found out that
all the folders in my PC have a gray backgrouind "Read-Only"
check box. That means the Read-Only attribute is not
available.

Therefore, the 'read-only' error is probably caused by the
user permission of the database, not the Windows users.

 

[cjeffwang]

I found the solution to my Read-Only problem.

http://p2p.wrox.com/topic.asp?TOPIC_ID=1425

--Jeffrey