DAO 3.6 and Access 2000:

I want to change the data type of a field from number to text, to perform some other operations on it. I have a feeling the Type property is read only from VB - although you can do this from the Access GUI.

Second I have performed lots of other field operations on my data and the field order (in the table definition screen) is now different to when I started. Once again in the access GUI you can drag the fields and reposition them as you wish - can you do it from VB? i.e. is there a way to order the fields collection.

Thanks in advance