Adding columns to a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
in my appplication, in runtime, i would like to add to a MSACCESS table 1 more column, then change the structure of the table
I tried with dataset and dataadapters, but won't work
there is a better method
thank yo
Fabrizio
 
The Jet database engine used by Access supports the ALTER TABLE command. You'll have write and execute it yourself as the DataSet and DataAdapter objects are not intended to change the structure of your database

The syntax of the ALTER TABLE command is straight forward

ALTER TABLE Foo ADD COLUMN Bar TEXT(10
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create label at run time 4
DataBase doesn't AcceptChange 2
using data tables to create XML - need to have a column be a complex type 1
Add Table to XML file using Dataset... 1
swf movie 1
Unable to Update A Table Schema Progmatically 1
Best way to move data from gridview to Sql table 1
ADO.NET and Autoincrement columns 6

Back
Top