Insert and delete Field

[tdonahue]

I would like to know how to insert and delete a field into a database with a macro. The first step I need is how to delete an existing field and that how to insert a new ID field with autonumber.

Tom

 

[PHV]

In the Jet SQL help file take a look at ALTER TABLE

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244