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.

Question

2.50/5 (2 votes)

See more:

C#

ASP.NET

Please suggest me a proper solution for this problem, I had tried a lot but didn't found solution for this error.

Posted 4-Mar-13 3:47am

BALBINDER4u

Add a Solution

Comments

[no name] 4-Mar-13 10:03am

The error is self explanatory.... Exactly what sort of a solution are you expecting from us? Either close the program that is using the file or give permission.

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 4-Mar-13 10:38am

Check somewhere in code you have not closed the connection.

Richard MacCutchan 4-Mar-13 11:35am

Looks to me like you are missing a filename.

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Andy Lanng · Answer 1 · 2013-03-04T06:13:00

This can happen if the permissions to view the file don't allow you to even read the directory contents. make sure that the file and directory are correctly shared and that you can navigate to it via exporer.

If you have already checked all of this then are you running Access front end with a different permission set to the logged on use?

Are you even using an Access front-end to Access back-end setup?

If the above does not help then please supply much more detail on how you are set up and what you are trying to do when you get this error

^_^

abdul subhan mohammed · Answer 2 · 2014-11-12T08:03:00

Solution 2

hope it will help you.

string path = Server.MapPath(fileuploadExcel.PostedFile.FileName);

Posted 12-Nov-14 8:03am

abdul subhan mohammed

Comments

ZurdoDev 12-Nov-14 15:29pm

Are you sure you posted this to the right question?

ZurdoDev 12-Nov-14 15:32pm

Also, you appear to be answering most of your own questions. With solutions like this one and the fact you seem to be answering your own questions consider yourself warned that you are likely to be tagged as abusing the system because it looks like you're trying to gain points through abuse.

abdul subhan mohammed 13-Nov-14 2:14am

Actually i was also facing the same problem and i tried this sol'n, it resolved it.
That's why i posted my sol'n but not for gaining the points, if u r a admin or u can contact admin, u can take all my points, make it to zero, i'm not at all concerned. Secondly i'm here just to gain others exp and want to share what i experienced.

Dusara Maulik · Answer 3 · 2014-11-12T17:32:00

Please see:
Connecting MS Access while another application using the same MS Acess File[^]
Open MS Access with OLEDB connection string and not have access create the .ldb lock file[^]
Connecting MS Access database when another application using the same MS Acess File[^]
https://social.msdn.microsoft.com/Forums/en-US/c90b1166-e5ee-43ff-a49b-9efe9f416475/opening-an-ms-access-database-in-exclusive-mode-using-adonet?forum=adodotnetdataproviders[^]

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.

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0