Forbedre forespørgselshastighed

Mig bekendt ... ja ...

Eller rettere, nej ... det mener jeg heller ikke man kan ... men du kan benytte de sammenkædede som tabeloprettelsels-grundlag for tabeller hvor du kan lave disse unikke nøgler

Ja, som det er p.t. henter jeg poster fra den sammenkædedet tabel ind vha. en tabeloprettelses-forespørgsel, ud fra en valgt dato, men det er selve det at hente dataene som tager tid, bare for en enkelt dato, tager det ca. 15 min. Der er tale om en tabel med 2.3 mill. poster i, hvoraf mit program skal bruge ca. 6-7.000 poster. Navision-tabellen bliver opdateret hele tiden og jeg har ikke lyst til at lave et job som henter de ønskede data ind i en SQL Server database tabel hver nat, vil gerne have dataene liggende kun ét sted.

Dont know much about Navision but have you tried using pass-through queries?
When you are in query design view right click on the area with the tables in and then choose SQL specific from the menu. Now you see Pass-Through.

In this mode you have to write the SQL so that it is in Navision syntax, not Access. The SQL gets sent to the server and is executed there. This will very likley help in performance.

When you execute a query in Access ALL records are dragged over the network whereafter Access filters out those meeting the criteria. Using Pass-through queries only those meeting the criteria are dragged over the network.

Yeah, tried the Pass-Through query - it said something like it couldn't find the table...but that was the Access query I just "converted" to Pass-Through - have NO idea what the Navision query syntax would look like.....(it's an ODBC connection, of course)

You could start by making a very simple select just to see if you can make a pass-through query.