Last post Apr 27, 2012 05:08 PM by rivdiv
Apr 27, 2012 03:56 PM|rivdiv|LINK
While trying to open a connection to to an excel sheet, I'm getting the following error:
The Microsoft Access database engine cannot open or write to the file ''. It is already opened exclusively by another user, or you need permission to view and write its data.
Something to note - I've been playing around with "owner" on my files the other day (which I shouldn't have - didn't really know what I was doing), and I wonder if this is a result of that. I have been able to open connections in the past.
Apr 27, 2012 04:14 PM|Mikesdotnetting|LINK
The appropriate user account (NETWORK SERVICE by default) needs MODIFY permissions on the folder that the Excel file sits in.
Apr 27, 2012 05:08 PM|rivdiv|LINK