amolgoel

Thanks for the information, Wyrd. Oh and I had figured out which Views are you talking about earlier :-) - Amol

Thanks for your interest Wyrd. It was indeed a permissions problem. There was a weird(I guess this is the correct spelling :-) ) way of granting ASPNET user Write access on DB, which someone suggested me how to do, and its working now. Though I am not using Views, for further information purposes only, do you know a way how to update Views. Thanks once again. Amol

Thanks Wizard...it works. Were you able to solve your problem? - Amol

Problem is not with code. It is with permissions for the Directory containing the Access file for the ASPNET user. Bad news... I don't know how do change permissions. I am waiting for replies for my post on the same matter. If I get anything will tell you. Happy Coding, Amol

Hi, Yes, I am getting the dreaded 'Operation must use an updateable query' in ADO.NET code I'm using to update an Access Database. From previous posts I know the error lies not in the code but with my permissions for the ASPNET user for the directory containing the Access file. I tried Windows Explorer to IIS Console to try and grant 'Write' priviledge to the ASPNET user, but couldn't find a way to do it. If I try to share the folder containing the File by using 'Web Sharing' tab it says 'The alias "LM/W3SVC/1/Root/FolderName" already exists. Please choose a different alias'. Even using a different name and then accessing the file through that name isn't helping. I spent atleast 5-6 hrs. on this today. I'd really appreciate if anyone could lead me to right direction in correcting this. If you think additional info is required to attack this, please do tell me, I'll post that. Thanks. Amol