Pages

Thursday 23 May 2013

How To Solve This Error "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 C#

How To Solve This Error "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 C#


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


How To Solve This Error "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 C#
How To Solve This Error "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 C#

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

How To Solve This Error "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 C#
How To Solve This Error "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 C#

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

How To Solve This Error "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 C#
How To Solve This Error "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 C#

 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

How To Solve This Error "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 C#
How To Solve This Error "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 C#

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

How To Solve This Error "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 C#
How To Solve This Error "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 C#

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

No comments:

Post a Comment