hi can anyone plz tell me how to create a ms-access database with table in run time
i mean i want to create a database when user run the application

thanks

Recommended Answers

All 6 Replies

Urgent sounds unfriendly. Being rude is not the best type of first post. Read the rules, learn how to ask a question.

Read forum rulesrules and homework policy here at Daniweb.

Also, some more details may be useful!
To create a database at run-time, you can't be running access, as it is a file-open type of application. You would need to have an access database containing the code too then create ANOTHER database, unless you are talking about writing a plug-in for access itself.
What are you trying to acheive from / by this?

i'm doing project in vb.net a window application i want to create a database and tables when application loads and ready to use

>i want to create a database.

Here it is.

thanks and could u tell me how to create table in that using programme

>how to create table in that using programme

Dim Cn as New OleDBConnection
Dim Cmd as New OleDBCommand

cn.ConnectionString="put_db_connection_string_of_database_you just created"
cmd.Connection=Cn
cmd.CommandText="Create table TestTable (col1 int primary key, col2 text(40))"
cn.Open()
cmd.ExecuteNonQuery()
cn.Close()
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.