469,281 Members | 2,450 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,281 developers. It's quick & easy.

Cannot Update. Database or Object is read-only.

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.
Jul 19 '05 #1
2 11184
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

"tamimi" <ta******@scranton.edu> wrote in message
news:07****************************@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.

Jul 19 '05 #2
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.

"Ray wrote:
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

Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Michael J. Astrauskas | last post: by
2 posts views Thread by Joe Fetters via .NET 247 | last post: by
4 posts views Thread by René Kabis | last post: by
3 posts views Thread by Michel Esber | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.