Database Update Error

[tamimi]

I have a guestbook form that inserts the fields into an
Access Database. The database is residing in the "fpdb"
folder that was created by FrontPage. The ASP page that
writes the data into the databse uses the
"recordset.addnew" method. The code was working fine a
couple of weeks ago, and now all of a sudden the error
message "Cannot update.Database or object is read-only"
pops up. The ASP code or the database was not changed or
modified in any way, neither were the permissions for the
account. Any ideas regarding this problem is truly
appreciated? Thanks. Here are my connection strings:

<%
Dim connectionToDatabase,recordset
set connection=Server.CreateObject("ADODB.Connection")
set recordset=Server.CreateObject("ADODB.Recordset")

connection.Open "Data
Source=c:\Inetpub\wwwroot\xxxx\fpdb\addnewrecords. mdb" &_
";Provider=Microsoft.Jet.OLEDB.4.0;"


recordset.Open "select * From Table", connection,1,2

recordset.addnew

recordset("socialsecurity")=request.form("ssnumber ")
recordset("name")=request.form("name")
recordset("age")=request.form("age")

recordset.Update
recordset.close
set connection=nothing

response.write "A new record had been added successfully to
the database"

%>

..

[Ray at]

[url]http://www.aspfaq.com/5003[/url]

Ray at work

"tamimi" <tamimin1@scranton.edu> wrote in message
news:0ce201c3be89$0c8e1160$a001280a@phx.gbl...

> I have a guestbook form that inserts the fields into an
> Access Database. The database is residing in the "fpdb"
> folder that was created by FrontPage. The ASP page that
> writes the data into the databse uses the
> "recordset.addnew" method. The code was working fine a
> couple of weeks ago, and now all of a sudden the error
> message "Cannot update.Database or object is read-only"
> pops up. The ASP code or the database was not changed or
> modified in any way, neither were the permissions for the
> account. Any ideas regarding this problem is truly
> appreciated? Thanks. Here are my connection strings:
>
> <%
> Dim connectionToDatabase,recordset
> set connection=Server.CreateObject("ADODB.Connection")
> set recordset=Server.CreateObject("ADODB.Recordset")
>
> connection.Open "Data
> Source=c:\Inetpub\wwwroot\xxxx\fpdb\addnewrecords. mdb" &_
> ";Provider=Microsoft.Jet.OLEDB.4.0;"
>
>
> recordset.Open "select * From Table", connection,1,2
>
> recordset.addnew
>
> recordset("socialsecurity")=request.form("ssnumber ")
> recordset("name")=request.form("name")
> recordset("age")=request.form("age")
>
> recordset.Update
> recordset.close
> set connection=nothing
>
> response.write "A new record had been added successfully to
> the database"
>
> %>
>
> .

[Aaron Bertrand - MVP]

> recordset.Open "select * From Table", connection,1,2

>
> recordset.addnew

Ugh. Do you know how horribly inefficient this is?

Anyway, for the error message, skim through:
[url]http://www.aspfaq.com/2009[/url]

--
Aaron Bertrand
SQL Server MVP
[url]http://www.aspfaq.com/[/url]