-
ASP ( its urgent )
Hi everyone
I am having a problem in saving data to Access Database from an ASP page.
I have opened connection to the database through ADODB.Connection.
I have a recordset opened.. ADODB.Recordset
the code seems to be as such :-
dim con
dim rs
dim sql
set con = Server.CreateObject("ADODB.Connection")
set rs = Server.CreateObject("ADODB.Recordset")
con.Open "Provider=Microsoft..........."
sql = "select * from UserEntry"
rs.CursorType = 2
rs.LockType = 3
rs.Open sql,con
rs.Addnew
rs.Fields("UserName").Value = user.....
........ and so on..
rs.Update
rs.Close
con.Close
But i am getting an error as such that the object or the database is readonly.. i cant avoid this error.. I would await all help regarding this matter..
Thankx.
Nayan
-
Check that the directory the database is stored in has write permissions.
DJ