Sir,
I am studying the Book Beginning ASP 3.0 and am new to asp.While working on the code examples of chapter 12 through 14 i faced a new problem. The datbase examples work fine when i run them on win 2000. But when i switch to win XP server and try to use: <recordset>.addnew
i receive the error that "couldnot update record. Databse or object is readonly".Even i cannot update a record. I have checked the mdb file to of access 2000 and is not read only. Although i can fetch data to be viewed on the borwser. PLz help.

__________________
------------------
Kaustav

my guess is that it is the database's property. Because sometimes when you convert a database it is automatically set as read only, and so you have to change the property. Just try to play around with it and change the property to not just read only... =p

Make sure your properties are not readonly like kyootepuffy said and while your at it make sure that you (as a website suer) have security provledges on the database file. I have had the same problem as I recall in the past when it dealt with security.

Chris

kilika & kyootepuffy
I have checked with the property of the mdb file. It is not set to read only. Also. To see if ADO has some problem i worked with three versions of the file. I hav worked with the files office 97, office 2000 and office 2002 versions. But all gives the same error.
"Error Type:
Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only.
/addnew.asp, line 17"
in my code line 17 is "rs.addnew " where rs is the recordset object

Have you checked whether the user under which your asp page runs has rights to change the file, not just read rights?

Since you are a beginner, you may not know that asp pages usually run under a special "anonymous" user called IUSR_machineName. To check permissions, right-click the folder where your database is and choose Properties then the Security tab. If IUSR_machineName is not in the list of users then Add it. Then give that user change permissions (Full Control) and re-run your asp page.

hth
Phil

Sir,
I have NTFS format on my server on WinXp. I think it is creating problem to add new record to a recordset. CAn you give me the steps how can i overcome this problem

------------------
Kaustav

Sir, thanx for ur help.
But an you be more specific. I am having an NTFS formatting on my win XP server. CAn you specifically give me th details of how to o it.
------------------
Kaustav

Kaustav,

I had nothing but problems when using the AddNew function. I never found out what it was. Basically, it didn't work for me.

You don't have to use that.

You can simply use a SQL "INSERT" statement. Open a connection and execute a SQL statement. It works great. If anyone knows any advantages for using AddNew, please let me know.

Example:
    Set oConn = Server.CreateObject("ADODB.Connection")
    oConn.Open strConnect

    strSQLStatement = "Insert into Test (Name, Address) Values '" & strName & "', '" & strAddress & "');"
    oConn.Execute strSQLStatement

Then you just have to make sure you close your connection. All is well.

Hi,

I use this INSERT code also, but I have 70+ fiels and values, and VBE gives error that too many lines or too much code...

Is there a workaround?