Re: Change Access Column Ordering

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

On Thu, 17 Jan 2008 08:06:03 -0800, T. Ford <TFord@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:

Is there a way using DAO to change column ordering? Obvious in the Access
application you can change the ordering via design view, but can it be done
via code?

Thanks,

T. Ford

Why would you want to?

Table datasheets have arbitrary ordering of both columns and rows. You can
create a Query based on the table to retrieve all or a part of the fields in
any order you like; the query can be used anywhere that the table could be
used.

I'm not sure if there's an easier way in DAO but the only way I can think of
would use the CreateTable method or a data-definition query to create a new
table with the fields in the desired order, and then append the data from the
old table into the new one.

John W. Vinson [MVP]
.

Quantcast