Creating an Access Database at Run time

Question

1.00/5 (1 vote)

See more:

Hello;

I want to create an Access Database at Run time. I used the code below. Although it creates a file, it can not be opened saying that it has unrecognized format. Could you please let me know how I can create an Access Database at Run time?

Thank you very much

...
string FilePath = FolderPath + "\\myDataBasae.accdb" +;
if (!File.Exists(FilePath))
            {
                File.Create(FilePath);
                OleDbConnection myConnection = new OleDbConnection();
                myConnection.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source= "
                                               + FilePath;
                OleDbCommand myCommand = new OleDbCommand();
                myCommand.Connection = myConnection;

                myCommand.CommandText = "CREATE TABLE myTable " +
                                          " (" +
                                            " ID int IDENTITY(1,1) PRIMARY KEY," +
                                            " Day DateTime," +
                                            " Events MEMO" +
                                            " )";
                try
                {
                    myConnection.Open();// This line raises an Exception
                    myCommand.ExecuteNonQuery();
                    myConnection.Close();
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.ToString());
                }
                finally
                {
                    myConnection.Close();
                }

            }

Posted 1-Aug-10 5:04am

ahhashemi

Add a Solution

Comments

mslliviu 2-Aug-10 2:37am

You should detail more the exception message. Maybe you can check the format of connection string, I don't use access but it seems that the string should be something like "Provider=Microsoft.ACE.OLEDB.12.0;Data Source= '\test.accdb'"

Christian Graus 2-Aug-10 23:56pm

Reason for my vote of 1
1 Vote for asking the same question over and over.

3 solutions

Solution 2

There is more to creating a database file than simply executing a File.Create() statement; this just creates an entry in the directory. Using Access to create a blank database file is probably your best bet, though Eddy's suggestion using VBScript may also work; I've never tried that.

Posted 2-Aug-10 17:54pm

Roger Wright

Solution 3

Why on earth do you want to create db on-the-fly? It simply is over complicating the whole code. Provide skeleton database with your application. If the database does not exist, simply stop further processing and display useful error message.

Posted 2-Aug-10 18:25pm

Yusuf

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)

Eddy Vluggen · Accepted Answer · 2010-08-01T23:13:00

Solution 1

Two alternative options;

Create an empty DB using Access and add it to the executable as a resource.

Use VBScript to create a new database (save as .vbs and execute)

VBScript

Set objConnection = CreateObject("ADOX.Catalog")

objConnection.Create _
    "Provider = Microsoft.Jet.OLEDB.4.0; Data Source = myDatabeest.mdb"

Posted 1-Aug-10 23:13pm

Eddy Vluggen

Updated 1-Aug-10 23:14pm

v2

Comments

Christian Graus 2-Aug-10 23:57pm

Funny, I told him that yesterday, too, in a different thread he started with the same question.