add/remove fields

[John]

Hi!
I use MS Access with ASP. I have a db with one table (so far things are
simple).
However, I want to be able to add/remove fields from my table using code,
and not from the design view.
Does MS Access supports such thing?

Thnx in advance.
John

 

[Dan Artuso]

Hi,
You can use an SQL statement to drop a field.
Here's a snippet from help:
ALTER TABLE Employees DROP COLUMN Salary;

Look up Alter Table in Help.