changing ordinal position in access table

  • Thread starter Thread starter adiel_g
  • Start date Start date
A

adiel_g

I want to re-arrange some of the fields in an access table. I know
this could be done from the previous microsoft database objects. I am
not sure if ADO.NET can do this. Can you change the ordinal position
of fields in a table from ADO.NET?

Thanks Before Hand,
Adiel
 
Yep, Jeff is correct. Why would you want to re-arrange fields?
Just use a select statement(s) that address fields by name instead of index
(which is a bad way to address them).
 
On 25 Oct 2006 12:43:24 -0700, (e-mail address removed) wrote:

¤ I want to re-arrange some of the fields in an access table. I know
¤ this could be done from the previous microsoft database objects. I am
¤ not sure if ADO.NET can do this. Can you change the ordinal position
¤ of fields in a table from ADO.NET?

No, not without dropping and re-adding the column.


Paul
~~~~
Microsoft MVP (Visual Basic)
 
Back
Top