Excel file attributes archive

The error message is as follows,. It is already opened exclusively by another user, or you need permission to view its data. If i set the prorperty of the excel file readonly and even if it is opened by some other users , my application works fine. If i reset the property of excel file then my application will show the error again.

This is because file is opened by Jet in writable mode that locks the file to prevent corruption during modification by multiple users. I cannot find properties for Jet, but I believe you could specify read-only or some sort of shared property in a connection string. The content you requested has been removed.

Ask a question. Quick access. Search related threads. This thread is locked. You can follow the question or vote as helpful, but you cannot reply to this thread.

I have the same question Report abuse. Details required :. Cancel Submit. Rohn MVP. Please click on the "Vote as Helpful " button! How satisfied are you with this reply? In the directory where the file is located, enter:.

To clear an attribute with attrib , use - the minus sign , for example:. Using the minus signs after attrib in the above example clears the System, Hidden, and Read-only attributes from the file.

This is document aift in the Knowledge Base. Last modified on Skip to: content search login.