1

I have made a window application that works very well when i ran through but after creating its setup it is throwing below mentioned exception. I have try to give full access to the database file but still it is not working.

system.data.oledb.oledbexception operation must use an updateable. query

i am using window 7 and installation folder is c:\program files\abc\ and access db is in same folder. Is this any issue of permissions? Please assist me to remove this exception.

Sandeep
  • 2,573
  • 3
  • 21
  • 28

1 Answers1

1

There can be some permission issue just refer this Link

http://www.mikesdotnetting.com/Article/74/Solving-the-Operation-Must-Use-An-Updateable-Query-error

Make sure the ASPNET account (or whatever account is in use at the time) has Change permissions to the directory where the .mdb file is located. Access needs to write some temp and locking files during the operation.

Nik
  • 86
  • 4
  • Thanks,bro..later i was granting permission to database file, but now i have tried to give permission to folder and it works..Thanks. – Sandeep Jun 20 '13 at 06:35
  • now here is one more question that how can i automatically give permission to this folder on the time of installation – Sandeep Jun 20 '13 at 06:35