Issue with OleDbConnection

Question

4.00/5 (1 vote)

See more:

Hi,

I am getting the below error. Please help me to solve this.

OleDbException was unhandled by user code
The Microsoft 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

What I did so far,
1) I have added an file upload control. Code in the button click,

C#

protected void btnUpload_Click(object sender, EventArgs e)
 {
         string strFileExtension = Path.GetExtension(fuList.PostedFile.FileName).ToString().ToUpper();
         string connstr = string.Empty;
         string strFileName = (fuList.PostedFile.FileName).Replace("'", "");
         if (strFileExtension == ".XLSX")
             connstr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source='" + (fuList.PostedFile.FileName).Replace("'", "") + "';Extended Properties=Excel 12.0";

         else if (strFileExtension == ".XLS")
             connstr = "Provider=Microsoft.Jet.Oledb.4.0;Data Source='" + (fuList.PostedFile.FileName).Replace("'", "") + "';Extended Properties=Excel 8.0";
         OleDbConnection conn = new OleDbConnection(connstr);
         conn.Open();
}

I got the above mentioned error at conn.Open()

2) I have tried the following method to solve this,
(I am using 64 bit windows 7 OS and MS Office 32 bit)
Created directory "C:\Windows\SysWOW64\config\systemprofile\Desktop "
And added NETWORK SERVICE and gave full permission
(Desktop Properties >> Security >> Added NETWORK SERVICE >> And gave full permission)

Posted 13-Nov-12 1:50am

N!dh!sh

Updated 13-Nov-12 1:56am

André Kraak

v4

Add a Solution

2 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)

Herman<T>.Instance · Answer 1 · 2012-11-13T03:04:00

maybe another program uses the files and then the above error occurs.
To see if you can have exclusive access to the file you can use this class:

C#

public class FileCheck
    {
        public static Boolean FileCanBeCopied(String FolderAndFileName)
        {
            Boolean canBeCopied = false;
            if (!String.IsNullOrEmpty(FolderAndFileName))
            {
                FileInfo fi = new FileInfo(FolderAndFileName);
                if (fi.Exists)
                {
                    FileStream stream = null;
                    try
                    {
                        // check if the file can be opened exclusive. If that is possible, then the file can be copied otherwise in transfer
                        using (stream = File.Open(FolderAndFileName, FileMode.Open, FileAccess.Write, FileShare.None))
                        {
                            if (stream.CanWrite)
                                canBeCopied = true;
                        }
                    }
                    catch (Exception)
                    {
                        canBeCopied = false;
                    }
                }
            }
            return canBeCopied;
        }
    }

Hassantga · Answer 2 · 2012-11-13T20:36:00

Solution 2

if the access file is open, then it will lock the file, so try to close the access file before running your application,

some times it requires restarting your computer to make sure that no one else is using the access file with you,

Posted 13-Nov-12 20:36pm

Hassantga