Home » Interview Q&A » asp.net Interview Questions » The Microsoft Jet database engine cannot open the file. It is already opened exclusively by another user.

The Microsoft Jet database engine cannot open the file. It is already opened exclusively by another user.

STUFF and CONCAT in SQL
Recursive SQL Query

The Microsoft Jet database engine cannot open the file ”.  It is already opened exclusively by another user, or you need permission to view its data.

I have already explain how to import Excel files using OLEDB, with extend to that topic if that file would be opened by some another user, you will be prompted “The Microsoft Jet database engine cannot open the file”.  It is already opened exclusively by another user, or you need permission to view its data.”

To resolve this problem, We have  to first check for whether this file is opened or not. To check that we could write code as below:

Whenever we call upload file we would call FileInUser Method inside that event or method as shown below:

That’s all how to find whether file is opened or not.

 

 

About

Hello friends, My self Dhruv Sheth, I have more than 6 years of Industrial experience as a Software Developer. In my career I got chance to work with asp.net, c#,Web API, JavaScript, JQuery, WPF, WCF , Windows Application, PostScript, vb.net, GhostScript etc. So I have decided to share my knowledge with everyone and finally I have come up with TechnoThirsty.

Leave a Reply

Your email address will not be published. Required fields are marked *

*
*

Time limit is exhausted. Please reload CAPTCHA.




DISCLAIMER:
The content is copyrighted to technothirsty.com and may not be reproduced on other websites without permission from the owner.You may contact us using the information below.