Add a new field to a table using queries

[jonney]

I have a split database and I would like to be able to add a field to a table using either a query or some code. I hope that makes sense

Thanks

Jonney

 

[jrbarnett]

CurrentDb.Execute "alter table TableName add column ColumnName Text (20)"

Change Text (20) to the data type and size you need when needed.

John

 

[Remou]

ADO with a data definition query is probably the best bet:

http://office.microsoft.com/en-us/access/HA102061121033.aspx

 

[jonney]

Thanks for the prompt replies. That is very helpful

Jonney