Can I return the fields that are in a table with a Query (Access)

C

Camper Joe

Is it possible to return a query that show me all the field names in a table?
Also,
I would like to add or remove fields in an Access table through code /
query. Is
this possible?

Thanks

CJ.
 
K

Klatuu

It is possible, but scary.
See VBA Help and look at the Microsift Jet SQL Reference for Data Definition
Language
 
Top