The Microsoft Jet database engine cannot open

Question

0.00/5 (No votes)

See more:

hello ,

I get Following error :

The Microsoft Jet database engine cannot open the file 'D:\AspProject\ExportToExcel\Web\UploadFiles'.  It is already opened exclusively by another user, or you need permission to view its data.

Posted 25-Dec-11 18:21pm

chetan virkar

Updated 25-Dec-11 18:24pm

Mehdi Gholam

v2

Add a Solution

3 solutions

Solution 1

If you use MS Access or Ms Excel as database then their are 4 types of options are their

1.Open
2.Open Exclusively
3.Open Read Only
4.Open Read Only and Exclusively

While you are doing modification,insertion or deletion in the database
you should open in open mode only .

while you are doing these operations, if you already open the db or any other application use it exclusively or read only you cant access it, you will get this error.

Posted 25-Dec-11 18:32pm

Sridhar Patnayak

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)

chetan virkar · Accepted Answer · 2012-01-31T22:19:00

C#

string strFileType = System.IO.Path.GetExtension(filepath.ToLower());
                      string sSourceConstr = String.Empty;


                      if (strFileType.Trim() == ".xls")
                      {
                          sSourceConstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source =" + filepath + "; Extended Properties=\"Excel 8.0; HDR=Yes; IMEX=2\"";
                      }
                      else if (strFileType.Trim() == ".xlsx")
                      {
                          sSourceConstr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source =" + filepath + "; Extended Properties=\"Excel 12.0; HDR=Yes; IMEX=2\"";
                      }


                      string sDestConstr = ConfigurationManager.ConnectionStrings["Class"].ConnectionString;
                      OleDbConnection sSourceConnection = new OleDbConnection(sSourceConstr);
                      using (sSourceConnection)
                      {
                          sSourceConnection.Open();

                          string sql = "select * from [" + dr["SheetName"].ToString() + "]"; //"select * from $",sheet
                          OleDbCommand command = new OleDbCommand(sql, sSourceConnection);

                          OleDbDataAdapter da = new OleDbDataAdapter();
                          da = new OleDbDataAdapter(command);
                          DataSet ds = new DataSet();
                          da.Fill(ds);
                          if (ds.Tables.Count > 0)
                          {
                              DataTable dt = ds.Tables[0];

                              if (dt.Rows.Count > 0)
                              {
                                  Users objUser = (Users)Session["UserSession"];
                                  string curUser = objUser.UserId;

                                  DataColumn dcUser = new DataColumn();
                                  dcUser.ColumnName = "CreatedBy";
                                  dcUser.DefaultValue = curUser;
                                  dt.Columns.Add(dcUser);

                                  DataColumn dcCreatedOn = new DataColumn();
                                  dcCreatedOn.ColumnName = "CreatedOn";
                                  dcCreatedOn.DataType = System.Type.GetType("System.DateTime");
                                  dcCreatedOn.DefaultValue = DateTime.Now;
                                  dt.Columns.Add(dcCreatedOn);

                                  int newsNo = dt.Rows.Count;
                                  string table = ("ZipUpload"+"_"+dr["SheetName"].ToString().Replace("$",""));
                                  string conString = ConfigurationManager.ConnectionStrings["Class"].ConnectionString;
                                  CommonBase objCommonBase = new CommonBase();
                                  objCommonBase.DeletTableData(table);

                                  FileUploadBase objFileUpload = new FileUploadBase();
                                  objFileUpload.BulkInsert(dt, table, conString);

                                  lblMessage.Text = "File uploaded successfully!  <br /> No. of Record: " + newsNo + "<br />";
                                  lblMessage.ForeColor = System.Drawing.Color.Green;

using This i solve My Problem Thank U Guys!

chetan virkar · Accepted Answer · 2011-12-25T19:11:00

my code is

C#

protected void btnUpload_Click(object sender, EventArgs e)
    {
        if (fpExcel.FileName.ToString() != string.Empty)
        {
            string filepath = Server.MapPath("UploadFiles");
            fpExcel.SaveAs(filepath + "\\" + fpExcel.FileName.Split('\\')[fpExcel.FileName.Split('\\').Length - 1]);
            gvwReport.DataSource = GetExcelData(filepath);
            gvwReport.DataBind();
        }
    }

    private DataTable GetExcelData(string filepath)
    {
        string oledbConnectionString = string.Empty;
        OleDbConnection conn = null;
        oledbConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + filepath + "; Extended Properties=Excel 8.0;";
        conn = new OleDbConnection(oledbConnectionString);
        if (conn.State == ConnectionState.Closed)
        {
            conn.Open();
        }
        OleDbCommand command = new OleDbCommand("Select * from [Sheet1$]",conn);
      OleDbDataAdapter objAdapter = new OleDbDataAdapter();
      objAdapter.SelectCommand = command;
        DataSet objDataset = new DataSet();  
       objAdapter.Fill(objDataset, "ExcelDataTable");
       conn.Close();  
        return objDataset.Tables[0];  
    }

on opening the connection i get above error!

The Microsoft Jet database engine cannot open

3 solutions

Solution 4

Solution 1

Solution 2

Add your solution here

Preview 0