Create Field in table and define it's position

[chris]

Can I create Field in a table and define it's position, for not being the
last field ?

ex. Table fields (Field1,Field2,Field3,Field4)

add Field5 and table fields to be (Field1,Field2,FIELD5,Field3,Field4)

Thanks a lot in advance!

 

[Douglas J. Steele]

Realistically, it shouldn't matter what order the fields are in in the
table. If you have a situation where the field order does matter, you can
create a query that orders the fields as desired, and use the query rather
than the table.

That having been said, if you're using DAO, the Field object has an
OrdinalPosition property that can be set before the Field object is added to
the Fields collection. There doesn't appear to be an equivalent property in
ADOX, although I suspect that it may be a provider-specific property that's
accessible through the Properties collection of the Column object.