Adding a Column to a Table

Can I add a column to a database table without dropping and recreating the table?

The problem is that everytime a user creates an action that requires a new table - at the moment I drop the table and recreate the table with the new column.

This requires lots of resources as I have to populate the table again.

Is there a design way I can go around this?

Thanks,
Biancaalter table <your table name> add <your new column> <column datatype>

look up alter table in Books Online for more info.|||if you use Access Data Projects for development, you dont have to bother with garbage like this..

it does it all for you.

startup access 2002 and go 'new project, existing data' and then setup the connection..

and then edit the table while it is in production without dropping the whole table and recreating.

ps - its the best sp development platform ive found ANYWHERE also!!|||>> and then edit the table while it is in production

Nice process - and a hint why it shouldn't be done like this.|||and its better than having to DTS data back and forth.|||Maybe but then why would you use dts for this anyway?