Cannot Update. Database or Object is read-only.

[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.

 

[Ray at]

Does your IUSR account (or whatever account is trying to .Addnew) have write
permissions to the directory that the .mdb file is in? Does someone have
the .mdb open in another interface, like Access, and have it in design more
or something?

Ray at work

 

[Roland Hall]

Hey Ray...

I think you were on the right track with the rights issue. If the database
was open in Access, you would get a sharing violation.

--
Roland

This information is distributed in the hope that it will be useful, but
without any warranty; without even the implied warranty of merchantability
or fitness for a particular purpose.