Hi. I want to insert a new field in access using visual basic 6.0. I have a a database called "info.mdb" and it has a table called "Table1" and it has fields "Name", "Age","Address" respectively. I want to insert a field called "Sex" BETWEEN "Name" and "Age". Please help me.... Thanx.