Inserting a new field in access thru vb6

[pj_b2sai]

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.

[Sic]

Here's a link That could help you.

In short :

Appending in no problem but inserting seems to require to create a new table with the new definition and then copy all the datas from the existing table ...