Hi All,

I have a DSNless connection setup for an MSAccess database. I have tested the code on the local host, and it works perfectly fine. I'm able to update the database. But when after moving the files to the Server and when I try to update the database through the webpage, I get the following error.

ASPCode:
ASPDescription:
Category:Microsoft JET Database Engine
Column:-1
Description:Cannot update. Database or object is read-only.
File:/cai/dbase/drmartin/writetodb.asp
Line:12
Time:4:31:21 PM
Date:9/8/2003
Browser:Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0)
URL:/cai/dbase/drmartin/writetodb.asp
Query:

What kind of permissions do I need to set for the database and how do I set it. I understand that the database should have a write permission, but is it necessary for the owner, group and others to have the write permission ?

My server doesnt support chmod so how do i go about changing the permissions ?

Thanks

Senthil

You didn't show your code. Does this help?

rs.open sql, conn, 3, 3

NOTE: 3, 3 is write mode for Access I think.