hello sir.i have a table name "trans".i want to add column in this table dynamicaly and also remove column dynamically.the column name will be given by d user.and i also tell the column number.suppose in my "trans" table there are three columns.the column names are "cake","pastry","totalquan".now i want to add a column name biscuit after the pastry column.how can i do this? this is my problem.please help me.my programe is write in vb.net and my database is in ms.access.help me please.

____________________________
ambarish sadhu

YOu can use SQL to add column to existing table, using ALTER TABLE and ADD COLUMN keywords.

ALTER TABLE table_name ADD column_name datatype

As for the "inserting column", you dont need to insert in in a particular place. You can insert it in the end, and when you fetch data from table, in SELECT statement you will set the order of the columns to be shown.

____________________________
If you find the answer helpful, please mark this topic as solved.