Adding a Field to a Table using code.

  • Thread starter Thread starter Guest
  • Start date Start date
Method 1: DDL
Execute a query statement such as:
"ALTER TABLE MyTable ADD COLUMN MyColumn TEST;"
"ALTER TABLE MyTable DROP COLUMN MyColumn;"

Method 2: DAO
Use CreateField() and then Append to the Fields collection of the TableDef.
Delete the Field from the Fields collection of the TableDef

Method 3: ADOX
Declare a new ADOX.Column, and Append to the Columns of the Table.


Use method 1 for a quick and simple approach.

Use method 2 if you want fine control over the properties of the new field.

Use method 3 if you are a maschochist. (ADOX is very buggy, with different
bugs in different versions so you never know what you will end up with.)
 
You must log in or register to reply here.

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

Data entry to table from a form 1
Data entry for a table from a form 2
How to export table from outlook into ms access table? 0
Update Two Tables Using One Form Contents 0
Data entry VBA 1
Use field to update multiple fields 4
How to subtract a number from a Mergefield? 0
VBA - retrieve data on last create named range from previous inserted named range 0

Back
Top