|
Subject:
|
Unable to update database on server
|
|
Posted By:
|
senthilpr_in
|
Post Date:
|
9/8/2003 4:53:24 PM
|
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
|
|
Reply By:
|
DaveGerard
|
Reply Date:
|
9/23/2003 11:43:14 PM
|
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.
|
|
