locked
The Microsoft Access database engine cannot open or write to the file ''... RRS feed

  • Question

  • User-577741185 posted

    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.

    TIA

    Friday, April 27, 2012 3:56 PM

Answers

  • User-821857111 posted

    The appropriate user account (NETWORK SERVICE by default) needs MODIFY permissions on the folder that the Excel file sits in.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, April 27, 2012 4:14 PM

All replies

  • User-821857111 posted

    The appropriate user account (NETWORK SERVICE by default) needs MODIFY permissions on the folder that the Excel file sits in.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, April 27, 2012 4:14 PM
  • User-577741185 posted

    Thank you.

    Friday, April 27, 2012 5:08 PM