Last post Aug 03, 2014 04:05 AM by Mikesdotnetting
Aug 03, 2014 12:55 AM|majd_wadi|LINK
I'm usuing OleDbCommand to update a cell in an excel file, I keep getting the error "Operation must use an updateable query".
I tried giving everyone permission on the excel file, also tried some suggestions online.
Any one has an idea what the problem is ?
Thanks & Regards,
Aug 03, 2014 04:05 AM|Mikesdotnetting|LINK
You need to give the user account MODIFY permissions on the
folder that the file is in as well as the actual file. The user account is either NETWORK SERVICE, IUSR_YourMachineName or IIS APPPOOL\NameOfYourApppool.