Changing Table structure on the fly

Tallon Wolle · January 20th, 2004, 10:41 PM

Dear All,

How can I change the property of field in a Table of Access2000 database in VB6. Say I have a table, Tbl in database dat.mdb and I want to increase the width of character field, fld from 25 to 30.

How can this be effected in VB6 code.

Thanks.

Tallon

Yehuda · January 21st, 2004, 10:36 AM

Execute a Sql ALTER TABLE statement through ADODB Connection.Execute. Look in Access's Help files for the syntax of an ALTER TABLE statement.

Yehuda