[2005] Chaning a MDB table

Can I add/edit/delete feilds in a .mdb database?

If so how?

Hi

A wee dangerous. You'll want to back up or make a backup of the table as sql can be a bit unforgiving. Try using sql view in Access to test it out on something not important first.


Alter Table SomeTableName
Drop Column SomeColumnName

Alter Table SomeTableName
Add Column SomeColumnName Datatype

I believe you can't delete an identity column, but you could alway make a new table.

http://www.vbforums.com/showthread.php?t=466658