Add and Delete Access Table

  • 11 years ago


    How can i add or delete table in Access 2003 from Vb.Net 2003 ???

    Can anybody help me...


  • 11 years ago

    I would try using ADO.Net to execute the DDL required to create or drop the table. Very roughly, the code would look something like this:


    Dim cnn as OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=myDB.mdb;Persist Security Info=True")
    Dim cmd As New OleDbCommand("CREATE TABLE(..........", cnn)


  • 11 years ago

    Thanks.... it's can run....

Post a reply

Enter your message below

Sign in or Join us (it's free).


Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“If Java had true garbage collection, most programs would delete themselves upon execution.” - Robert Sewell