How can I add a fields to a DB with VB code?

[PaulB]

Hi

I have a program that is in use at a lot of locations. I've produced a large update, but this involves adding a new field to one of the database tables.

Is there a way to do this through VB code?

I currently use DAO to connect. The database is Access 97.


Thanks

[ernmeister]

I use the CreateField method to insert new fields into tables. You might look it up in the Help file and see if it would apply to your application.

ern