Field order in view using Access GUI

[kerpet67]

When I create a view in Access, it seems to choose to order the fields
differently than from top to bottom in the view.

example

Field1
Field2
Field3
Field4

When displayed it comes out like

Field2 Field1 Field3 Field4

This may not seem important but from an extract to excel point of view,
it is.

Curiously though, when you create the same view in Enterprise Manager
it formats correctly.

Any Ideas?

Using SQL Server 2000 SP3, Office 2003 professional

Thanks

Peter K

 

[aaron.kempf]

yes; drop and recreate the view.

it stores the ordering of the columns in an extended property; I
believe.

I've been asking MS for management tools for that extended properties
table for a long long time. (the ability to remove all extended
properties for a table; for example)

 

[aaron.kempf]

also; I claim that Microsoft isn't taking the idea of a VWDB = Very
Wide Database seriously enough.

Yes; it breaks normal form.
but they need to be able to deliver a good experience for people that
have 200 columns in a table for example.

for example

Select * {ABC} From MyTable
- this would return all the columns in alphabetical format

Select * {Like 'cMy%'} From MyTable
- this would return all the columsn that are like cMy% from the table

I believe that Microsoft needs to drop the theory; and support these
syntax.

no matter of Linq or VS.NET 2009 is going to make this easier.

QUIT THE THEORY, MS-- NOT EVERYTHING FITS UNDER 3rd NORMAL FORM