The Microsoft Office Access database engine cannot open or write to the file

[GoogleCodeExporter]

I have deployed an ASP.Net dashboard for my client using your component to
extract data from Excel spreadsheets.  The data in the spreadsheets is
updated on a monthly basis.  The spreadsheets are generated in another
system (with the same file name and column names) are new copies are FTP'd
to the location from which my web application read them.  This process
worked fine until yesterday.  My client generated the spreadsheets with the
same file name, however, the columns names were not the same.  As a result,
the dashboard did not show the data correctly.  I reverted the spreadsheets
to the original copies but now I see the following error in the browser
(see screen shot): 

"The Microsoft Office 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."

I saw this error while doing my development because the Excel files were
open while ASP.NET was trying to read from them.  However, the files are
not open anywhere on the serverby any user.  I have also restarted the
server (in case there was a file lock) and even recreated the IIS virtual
directory.  The Excel files also have full control permissions for all users.  

Strangely, when I debug the application through Visual Studio I do not see
the error at all and the data is displayed correctly.

I just updated to version 1.2.64 this morning just in case the issue was
already resolved.

I am at a loss here of what might be happening.  Have you seen this error
before?  Do you know a fix?

Original issue reported on code.google.com by nosnibor...@gmail.com on 27 Apr 2010 at 2:31

Attachments:

• [linqtoexcel error.png](https://storage.googleapis.com/google-code-attachments/linqtoexcel/issue-19/comment-0/linqtoexcel error.png)

[GoogleCodeExporter]

This issue has been resolved.  This was a case of "ownership" of the files.  The
ownership was changed by FTP, thus appearing as locked to the linqtosql 
component. 
Once ownership was changed, the files were deleted and new copies were uploaded,
everything worked like a charm.

Original comment by nosnibor...@gmail.com on 27 Apr 2010 at 3:20

[GoogleCodeExporter]

Original comment by paulyo...@gmail.com on 28 Apr 2010 at 3:28

• Changed state: Invalid

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

Hi

"The Microsoft Office 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."

In my PC only .how to resolve it.

Original comment by vs.vsm...@gmail.com on 24 Sep 2014 at 5:43

[GoogleCodeExporter]

Try rebooting your computer

Original comment by paulyo...@gmail.com on 24 Sep 2014 at 11:06

• Changed state: Done

[GoogleCodeExporter]

Not Yet To Solve. 

Tell Me Steps to solve the issues.

Original comment by vs.vsm...@gmail.com on 25 Sep 2014 at 5:30