Sortering i linked view

The data in the table isnt necessarily sorted in the same way as your view, and in fact doesnt really matter. You could say the table is just a place for holiding the data, and view etc are for viewing.

Tabellen er linked til mit view, og jeg forventer derfor at tabellen viser præcist det mit view viser ?!?

It doesnt work like that. The table holds the data and views are usied to show the data in different ways. In a view you can sort on one or mor4e fields but that doesnt have any effect on how the data is soretd in the table. Just think, two people make two different views sorted differently. Which persons view decides how the data in the table is sorted?

Jeg troer at du misforstår mig.

Jeg har nogle tabeller på sql-serveren. Jeg laver et view på sql-serveren, som bruger flere tabeller (kun fra sql-serveren), som joines, og der er forskellige kriterier for mit view, samt en sortering.

Når jeg har lavet mit view på sql-serveren, ønsker jeg at bruge de returnerede data i en access frontend, og jeg linker derfor mit view fra sql-serveren, ned i access-frontenden. Jeg linker ikke nogle tabeller, blot mit view.

Herefter er mit view linked som en tabel i access, med de data mit sql-server view returnerer, men uden sorteringen (men afgrænset korrekt).

OK, now I understand you, your linking your view in Access through linked tables manager.

The view should return the data in the correct order. You havent sorted the view in Access in any way? Open the view inAccess and then right click with the mouse. Now you will be able to Remove filter/sort

Have you tried removing the filter/sort?

Der er ikke noget fiLter, og selvom jeg trykker fjern filter/sortering, så ændres sorteringen ikke.

sorry cant do much to help you jobless

Måske er det et sql 2005 express issue.....

It could be, but you dindt mention that it was 2005 express edition. The ODBC drivers your using may not support SQL 2005