Permission problem for DB folder?
-
Hello all, I am trying to insert a record into an MS Access table from my ASP.NET page. But it shows this error: "Operation must use an updateable query." I tried running the INSERT statement directly as a query in MS Access and it worked fine. I understand the reason for the above error is because I donot have the proper write rights. The MS Access table is in a DB subfolder inside my application folder. When I look at the properties for this DB folder, I see the Readonly box is dimly checked. If the error is due to permission problems, how can I give proper rights to the DB folder? I tried unticking the readonly option and clicking apply. But later when I again check the folder properties, the readonly tick remains. Please help... Thanks, Smitha Every person, all the events of your life, are there because you have drawn them there. What you choose to do with them is up to you. -- Richard Bach
-
Hello all, I am trying to insert a record into an MS Access table from my ASP.NET page. But it shows this error: "Operation must use an updateable query." I tried running the INSERT statement directly as a query in MS Access and it worked fine. I understand the reason for the above error is because I donot have the proper write rights. The MS Access table is in a DB subfolder inside my application folder. When I look at the properties for this DB folder, I see the Readonly box is dimly checked. If the error is due to permission problems, how can I give proper rights to the DB folder? I tried unticking the readonly option and clicking apply. But later when I again check the folder properties, the readonly tick remains. Please help... Thanks, Smitha Every person, all the events of your life, are there because you have drawn them there. What you choose to do with them is up to you. -- Richard Bach
Try using the attrib command from the command line. attrib -r or attrib /? for more help. -Thea-