sql top og order by problem

Most probably because there are more than 3 records with the same value so all are returned with that value

Try
SELECT DISTINCT TOP 3

Then I get the following error
Fejltype:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access-driver] Der kan ikke medtages et felt af typen Memo, OLE eller Hyperlink Object, når du markerer de unikke værdier (teaser).
/aalborgdh/default.asp, line 21

nickbuus>This works in Access XP!

SELECT DISTINCT TOP 3 nyheder.*
FROM nyheder Order BY submiteddate DESC;

Another idea is to make the query in the Access database and then select the query in your ASP

Select * from YourQuery

and?