add/remove fields

  • Thread starter Thread starter John
  • Start date Start date
J

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
 
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.
 
Back
Top