C# - 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

Introduction:

Here I will explain “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.” problem solution in asp.net using C# and VB.NET.

Description:

In previous articles I explained Import/upload data from excel to gridview in asp.net, Export selected rows of gridview to excel/word document, Export gridview data to pdf in asp.net and many articles relating to Excel, Gridview, SQL ,jQuery,asp.net, C#, VB.NET. Now I will explain how to solve the problem of “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 asp.net using C# and VB.NET.

In one application I got requirement like Read or Import data from excel sheet to gridview and upload excel data to SQL database once implementation completed I tested it in local everything working fine. After I deployed application in server machine and tried to run then I got an error like "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”. 

To solve this problem we need to grant the NETWORK SERVICE account modify permission on my folder where our excel files will sit for that follow below steps.

 

     1.    Select your folder >> Right click on folder and select properties like as shown below 

     2.    Once properties opened >> Select Security Tab >> In that click on Edit button to change the permissions like as shown below

     3.    Once you click on Edit button another window will open in that select Add button like as shown below

     4.    Now click on Add button >> Another window will open in that enter “Network Service” as name >> click on Check Names like as shown below

     5.    Once “Network Service” added set permissions for Network Service and click ok like as show below

Once set network service permissions run your application i hope this will fix your problem.

If you enjoyed this post, please support the blog below. It's FREE! Get the latest Asp.net, C#.net, VB.NET, jQuery, Plugins & Code Snippets for FREE by subscribing to our Facebook, Twitter, RSS feed, or by email.

Subscribe by RSS Subscribe by Email