Add and Delete Access Table

• • Reply

  13 years ago

  by jebat

  boedax's malay

  , Indonesia

  Joined 14 years ago

  Hiiiiiiiiiiiiii,

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

  Can anybody help me...

  Thanks..

  Report abuse
• • Reply

  13 years ago

  by TimL

  Tim Leung

  Berkshire, United Kingdom

  Joined 13 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)

  cnn.Open()
  cnn.ExecuteNonQuery
  

  Report abuse
• • Reply

  13 years ago

  by jebat

  boedax's malay

  , Indonesia

  Joined 14 years ago

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

  Report abuse